Thanks to everyone who has participated in the first 5 weeks of Workout Wednesday for Power BI. We have a new dataset again this week to help us explore some useful features that are not familiar to all users. This week we are focused on making sure labels in our visuals are readable and useful, including making room for long labels in bar charts and putting values on rows in a matrix.
While we encourage everyone to participate in as many challenges as you’re able, you can start fresh with week 6 – there are no prerequisites for this report.
- We are using a new dataset this week. Please download the starter Power BI Desktop file here. Remember that you must be on a PC to use Power BI Desktop.
- Filter the report page to show only years after 2013.
- Create a matrix that shows intakes and outcomes by animal type. The measures should be shown on rows and animal types shown on columns. Set the text size to at least 9 pt.
- Create a column chart to show outcomes by outcome type. Set the text size to at least 9 pt (Note: Because the visual is responsive, it might not actually render as 9pt, but that is ok). All labels on the x-axis should have a horizontal orientation (not diagonal). Some may require wrapping to a second line.
- Create a column chart to show outcomes by animal sex. Set the text size to at least 9 pt. All labels on the x-axis should have a horizontal orientation (not diagonal). Some may wrap to a second line.
- Create a bar chart to show outcomes by breed. Set the text size to at least 9 pt. Format the bar chart so that the breeds on the y-axis are not truncated.
- Create a horizontal slicer with year values. Change the slicer header to read “Select a year to filter the data”.
- Set the interactions between all visuals on the page to Filter.
- Use the cross-filtering functionality in the report to find out how many parakeets were adopted (the number of adoption outcomes) in 2020.
Fonts, colors, and page formatting are at your discretion. If you would like to use the background image shown, you can download it here.
This week’s data set uses data from the City of Austin, Texas Open Data Portal. You can access the raw data on their website. We’ve already created the model for you. All you need to do is download the Power BI desktop file and start building visuals!
The dataset contains animal intakes and outcomes at the Austin Animal Center from October 2013 to Feb 6, 2021.
When you open the file, you may notice that there is a second report page containing resources. Please take a look for details on the source data as well as how to make room for long labels in bar charts and how to put values on rows in a matrix.
After you finish your workout, share on Twitter using the hashtags #WOW2021 and #PowerBI, and tag @JSBaucke, @MMarie, @shan_gsd and @dataveld. 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.