Introduction
This week we’re revisiting Meagan’s challenge where we built a bar chart with long labels. We’re going to use a trick recently unveiled by Bas (@howtopowerbi on Twitter) to create custom labels for bar charts.
If you have long labels in your bar chart, they may be truncated depending on the size of the bar chart. Using this method, you’ll add your labels essentially as a row in the bar chart, enabling them to display fully and be readable!
Check out the interactive report below.
Requirements
Get and transform data
- Get data from the web or use Meagan’s pre-built data model.
- Create a placeholder measure with a value of 0. You’ll use this to make space for your data labels in the bar chart.
- Create a measure that will display your data label. In this case, make your measure display the animal breed.
Create your bar chart
- Add a bar chart to the canvas
- Turn the data labels off
- Add a custom data label
- Add any other visuals that you’d like!
- Ensure that all visuals meet the minimum standards of having alt text, that the tab order in your report makes sense, and that your color choices meet the minimum standards.
Dataset
There are 2 ways you can get data for this week’s challenge!
- Simplest: use the pre-built .pbix file that Meagan built in the 2021 week 6 challenge or
- Get data directly from the Austin, TX government website using either the API or the download function.
Share
After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.
Solution
Solution File available for download via Data Stories Gallery.
Watch Bas’ (@howtopowerbi) 😃original video below!