2021 Week 3 | Power BI: Report Interactivity

19 Comments / Power BI, Workout Wednesday / By

Introduction

Thanks to everyone who participated in Week 2 of #WorkoutWednesday – Power BI edition. If you are joining this week, you may want to revisit the first couple challenges as this week will build on the data model that we created in W01 and the basic KPI report that we built in W02. This week we are going to be adding a slicer and interactivity to our basic KPI report.

Requirements

  • Add a slicer for [Year] to the report. 
  • Edit Interactions for the slicer to have it only slice the KPIs and bar charts (not trends)
  • Edit Interactions of the Conference breakdowns so that they filter the KPIs and Trends on click. 
  • Use colors to differentiate between metrics
  • Figure out how much money the MAC conference made in 2016

Dataset

This week uses a data set that breaks down NCAA athletic department expenses and revenues by year. You can get it here at data.world. This is the same data set that was used in W01. 

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

19 thoughts on “2021 Week 3 | Power BI: Report Interactivity”

  5. Chromeuser

    -8,301,998.5 for me, might be related to the variation on data published, mentioned on previous weeks, or I might be an error ? 🙁

  6. Mark Shipman

    Hey, excellent series. As a complete newbie to Power BI, seeing how I should have solved it is so awesome. I am participating, but don’t twitter so no tags (apologies).

  8. Ann

    I’m loving this – I did the first two weeks on time, and am playing catch up right now.
    But tell me, is there a way I can format the negatives on the area chart to show in a different color than the positives as easily as I can with the bar chart?

  10. Sameer Waje

    The trend lines are looking different from week 2 assignment? Can you suggest how to do it?

  11. Redona

    You choose the ‘Area Chart’ type instead of the ‘Line Chart’. (in the ‘Vizualizations’ menubar on the right)

  12. Kalaiselvan

    It’s visual type, you can change the visual from ‘Line chart’ to ‘Area chart’ for trend charts

  16. Sonali

    Hi, could anyone please guide me on how to add shading below the line in a line chart?

    Thanks,
    Sonali Jha

  17. Dean Bukovac

    Just tried and finished this weeks challenge with help from the video.
    Enjoying learning the concepts

  19. Minh

    Maybe I am late now for knowing this joyful and meaningful BI task but it gave me a lot, thanks
    My answer for MAC’s conference profit in 2016 is they lost $8,293,724

Comments are closed.

Scroll to Top