Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello ,
i have the report that show me the top 3 of my products + Others like as bellow :
I have a measure that show me the rank, of my product and i want to display the stacked bar based on my Rank value , for example for the date 7/11/2022 , the product in yellow was sold more than Orange the result that i want for date 7/11/2022 Bleu-Yellow then Orange .
The rank value give me the right result but i didn't see on the chart how can i filter by the rank .
I tried the tooltip for sorting but didn't work .
I joined a pbix to have an idea about my measure.
Any help to fix that ?
Thanks
try Throw in your [Rank] in Y-axis and throw in [Top N SUM] in a tooltip
@Anonymous , Based on what I got so far, check if this can help
Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE
Hi @amitchandak
I don't have any problem with top N+others but the problem that I have is sorting the stucked bar based on rank value
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |