Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello Team,
Country | Sales |
India | 900 |
Srilanka | 500 |
Germany | 300 |
Australia | 1000 |
Belgium | 1200 |
Bangladesh | 5500 |
Poland | 400 |
Country | Sales |
Bangladesh | 5500 |
Belgium | 1200 |
Australia | 1000 |
India | 900 |
Srilanka | 500 |
Others | 700 |
Solved! Go to Solution.
Hi @jaideepnema/@Balhemkan ,
Can you please try using this free Pie donut Chart visual from x-viz. The free version gives you the Option to Rank the data as you required by showing TOPN and rest in others.
https://xviz.com/visuals/advanced-pie-donut/
Regards
Proud to be a Super User!
Hi @Balhemkan ,
The visual mentioned by @FarhanAhmed meets your needs, and there is no need to create a new calculated column.
If you want to highlight the slicer option in the pie chart, try "Enlighten Slicer" visual.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Balhemkan ,
The visual mentioned by @FarhanAhmed meets your needs, and there is no need to create a new calculated column.
If you want to highlight the slicer option in the pie chart, try "Enlighten Slicer" visual.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Balhemkan ,
You can create two calculated columns
Top 5 Countries =
var rankval= RANKX(Data,Data[Sales],,DESC,Dense)
var others=IF(rankval<=5,Data[Country],"Others")
return others
Other Countries = IF(Data[Top 5 Countries]="Others",Data[Country],BLANK())
Hi @jaideepnema/@Balhemkan ,
Can you please try using this free Pie donut Chart visual from x-viz. The free version gives you the Option to Rank the data as you required by showing TOPN and rest in others.
https://xviz.com/visuals/advanced-pie-donut/
Regards
Proud to be a Super User!
It is working but based on selection it not showing
Example if I select australia based on selection top 5 countries we want
Could you please help
External Filters are going to show only their status in the Visual, When you Select any country it shows that country it self. The filter context should be some thing else to show Top 5 .
I think you need to explain the objective.
1. When you Select Australia do you want Australia and their down below countries
2. What is the business context show the Top5
It will help us to give you a better solution!
Proud to be a Super User!
To get the desired result as shown in the picture follow the Video
https://drive.google.com/file/d/1joxWn6FCWlXJ_SdVkZkOCZKUVUezvhti/view?usp=sharing
Proud to be a Super User!
If we use this . Filter's are not working. Based on our selection we want top 5 and rest all in others
In Filter which field you are adding. IF you add the Grouped column Filter works based on selected country! I think some more information is required to explain this
Proud to be a Super User!
In filter I'm using country column. User don't want to see"other " In filter. So I'm using country column and based on that country top 5 highest countries
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |