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.
- 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
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.
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.
15 thoughts on “2021 Week 3 | Power BI: Report Interactivity”
MAC lost -8,293,274, is this right can anyone confirm ?
That is correct!
Did MAC lose 8.29 million? in 2016, is that the answer to the question?
I hope so as that’s the answer I had! 🙂
-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 ? 🙁
Hi! Did You check out subtotals in PQ?
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).
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?
Thanks for bringing the Power BI series. Its really helping me to learn very quickly.
The trend lines are looking different from week 2 assignment? Can you suggest how to do it?
You choose the ‘Area Chart’ type instead of the ‘Line Chart’. (in the ‘Vizualizations’ menubar on the right)
It’s visual type, you can change the visual from ‘Line chart’ to ‘Area chart’ for trend charts
as in 03 – Jun – 2021,
MAC conference made -8,301,999 in 2016
Thanks for these. Trying to do a few each day