Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
What is the easiest way to show just the top 15 items in a report? Example is I want to show the top 15 products in sales for the day. I will have hundreds of products in the data but only want the top 15.
Thank you,
Joseph
Solved! Go to Solution.
I use the Rank X measure for my products in the filter area of the visual (or whole page as needed). Then, when I add other values, there is nothing to break. I don't put the Rank X in the visual, I just use it as a filter for the page/report. In fact, I usually fill in all other information then apply it last to pull up my top 25.
Proud to be a Super User!
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |