2021 Week 6 | Power BI: Long Labels

Introduction

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. 

Requirements

  • 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.

Dataset

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. 

Share

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.

Solution

25 thoughts on “2021 Week 6 | Power BI: Long Labels”

    1. Meagan Longoria

      Hi, Gamu. The file is still there, and I have verified it is available via that link. Let me know if you are still having trouble accessing it, and I’ll find another way to get it to you.

  1. When I try to use the cross-filter, I have a problem:
    When I choose bird from the matrix and choose adoption from the chart. Power BI cannot apply both filter, I can only filter bird or filter adoption. Not both.
    I dont know what is wrong, I follow the solution

    1. Shannon Lindsay

      Hi Nayaab! You are welcome to connect to the data directly to create your own model! We always try to include the original dataset (mentioned above as the raw data on the website) so that you can create your own model using Power BI desktop! Let us know if you have additional questions.

  2. Hello,
    I was not able to download the .pbix file due to Onedrive error 103. After much struggling trying to duplicate your data model with the data files, I still was not getting the correct results.

    Then I discovered that if I open the Onedrive link while NOT logged in to Onedrive it would allow me to download the .pbix.

    I long for the day everything related to Power BI doesn’t frustrate me to tears. Until then I’ll keep the Kleenex handy I guess.

    Thanks for the series!

    1. Shannon Lindsay

      Hi Jon! Glad you got it figured out, and this is probably a tip that others can use as well. Apologies for the frustration but thrilled you got it to work! Thanks for your support and participation 🙂

    1. Hi Deepika – I am able to access using the existing link. Are you trying to download the .pbix file from the OneDrive link? Try using a different browser to see if that solves the problem.

  3. It’s really amazing learning through WoW. As a newbie in power BI, I find it really interesting and amazing. I can’t wait to complete the entire course 🤩

  4. Hello.

    I didn’t get how you created the button with the label “Data source information”, could you kindly help explain the process to me?

    Thanks.

    1. The video is posted. It’s on this page in the solution section. You can also search YouTube for Workout Wednesday and find the Power BI playlist for the year of the challenge.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top