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,
With the guidance of PBI community members I was able to create a dashboard for TOP N ( top 6 and bottom 6 ) performers in a single visual. Now i need your help to overcome below mentioned issue.
My top N ( top 6 ) side of my visual is perfect as sales amount is not same for any of the dealers ( screenshot attached )
The issue is with TOP N ( bottom 6 ) as many dealers have same sales figure ( eg: 1 ) hence it looks like this ( screenshot). I would like to have a bucket wherein all the dealers with sales figure 1 is placed in one group , then all the dealers with sales figure 2 as another group....like that. This goups only should be shown in the visual. So that bottom 6 groups will have a good looking visual
regards,
dsmitha
Solved! Go to Solution.
Hi @dsmitha ,
Power BI provide a way to group the item with same values. New group.
For more details you can refer this article:
Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dsmitha ,
Power BI provide a way to group the item with same values. New group.
For more details you can refer this article:
Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-chenwuz-msft,
thank you very much, it solved my issue
regards,
dsmitha
@dsmitha , Try to use rank, with tie-breaker
Rank Tie breaker
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-...
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
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 |
---|---|
117 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
106 | |
104 | |
89 | |
65 |