In this video you will learn how to filter the top N values shown in your bar chart visualization using a slicer.
- This technique uses one measure that generates a number 1-10, that will be applied to a slicer.
- Another measure will basically rank all of the values associated with your data bars and only return the values that are less than or equal to the number you select in the slicer.
The comments that I apply to the DAX function should help make it easy to understand. I have to give a shoutout to GilbertQ from the PowerBI community for coming up with the initial approach which I tweaked for the video.
As always, If you find this type of instruction valuable make sure to subscribe to my Youtube channel!