How to group values in a bucket

[dsmitha]

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

[v-chenwuz-msft · Accepted 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.

[dsmitha]

Hi v-chenwuz-msft,

thank you very much, it solved my issue 

regards,

dsmitha

[amitchandak]

@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/