2021 Week 6 | Power BI: Long Labels

30 Comments / Power BI, Workout Wednesday / By

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

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

  2. Gamu Perekwa

    Hi, the link for the PowerBi starter file is now longer downloadable. Kindly restore. Thanks

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

  5. rita

    you can use “Format Painter” to format all the tables in same pattern at one go 🙂

  9. Ngan Anh

    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

  10. Meagan Longoria

    After selecting bird, you have to hold down control or shift so you can select multiple items.

  12. Nayaab

    Hi
    Where can I practice creating models since you create the models for us in the weekly challenges.
    Thanks

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

  15. Jon

    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!

  16. 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 🙂

  18. Shannon Lindsay

    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.

  19. Nnadike Edeh

    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 🤩

  20. Chris

    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.

  22. Rithi

    To Admin,
    Please post the video, so that it will be useful to follow as a beginner and its good for learning

  23. Meagan Longoria

    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.

  25. Meagan Longoria

    The file is still there and available. Try using a private browser window to access the link.

  26. Tom

    Hi, I’m enjoying going through this series from the start.
    In the matrix how did you get the column headers to be sorted by the totals, so starting with Dog first instead of alphabetically with bird first?
    Thanks!

  27. Shannon Lindsay

    Hi Tom – in a matrix visual you can use the ellipsis menu in the top right-hand corner, where you should see a “Sort by” menu option. There you can indicate to sort by the value rather than the animal. Let us know if you have other questions! And thanks for being here!

  29. Yel

    Good day! Do you have video on how to do the data model? I’m struggling to do it as neat as your data model. Thanks

Comments are closed.

Scroll to Top