2023 Week 17 | Power BI: Peaches’ Parameters and Bowser’s Bookmarks

Power BI Desktop

1. Create a Measure for the Sum of the values column
2. Create a measure to rank the characters based on the measure you just created.
3. Create a field parameter to choose between Rank and Value (the two measures you just created in steps 1 and 2
4. Create a single selection Slicer for the field parameter
5. Get the Chiclet slicer from ‘Get more visuals’
6. Create a Chiclet Slicer for the Character Class
7. Create the visuals
8. Create a bookmark to show Rank in Visuals
   1. Ensure bookmark does not impact chiclet slicer for ‘class’
   2. Ensure the bookmark keeps Y axis sorted ‘Class’ ascending
   3. Ensure bookmarks don’t change ‘display’
9. Create a bookmark to show Values in Visuals
   1. Ensure bookmark does not impact chiclet slicer for ‘class’
   2. Ensure the bookmark keeps Y axis sorted ‘Rank’ ascending
   3. Ensure bookmarks don’t change ‘display’
10. Assign a button navigator to the bookmark
11. Set slicer to hidden
12. Add a Mario Kart background image if it pleases you!
13. Extra points if you can create any/all of the visuals with Deneb!
14.