Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to build a table that will only bring back the top 20 seller and another that brings back the bottom 20 sellers from a data set. I thought i had achieved this with using the TopN filter. However when data sets change the number of rows brought back is random and never sticks to the 20 mark that i want it to do. Can anyone point me in the right direction of what i am doing wrong.
Thanks,
Solved! Go to Solution.
Hi @Anonymous,
You could add 2 columns to the dataset. One using RANKX ascending and one using RANKX descending.
Then use the additonal columns to filter the visuals to only show ranks of 20 or less.
Hope this helps.
Thanks,
George
Hi @Anonymous,
You could add 2 columns to the dataset. One using RANKX ascending and one using RANKX descending.
Then use the additonal columns to filter the visuals to only show ranks of 20 or less.
Hope this helps.
Thanks,
George
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |