Forum Discussion
Helper IIIPie chart with others
Hello Team,
In that I am pulling two columns
| Country | Sales |
| India | 900 |
| Srilanka | 500 |
| Germany | 300 |
| Australia | 1000 |
| Belgium | 1200 |
| Bangladesh | 5500 |
| Poland | 400 |
like.....
| Country | Sales |
| Bangladesh | 5500 |
| Belgium | 1200 |
| Australia | 1000 |
| India | 900 |
| Srilanka | 500 |
| Others | 700 |
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
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.
9 Replies
- VijayP
Community Champion
To get the desired result as shown in the picture follow the Video
https://drive.google.com/file/d/1joxWn6FCWlXJ_SdVkZkOCZKUVUezvhti/view?usp=sharing
BalhemkanIf we use this . Filter's are not working. Based on our selection we want top 5 and rest all in others
- jaideepnema
Solution Sage
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 othersOther Countries = IF(Data[Top 5 Countries]="Others",Data[Country],BLANK())and then use these two columns like this to create the pie chartHere is the pbix in case requiredPlease accept this as a solution if your query has been answered !!Appreciate a Kudos 😀
FarhanAhmedHi 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
- Balhemkan
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
- VijayP
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 countries2. What is the business context show the Top5
It will help us to give you a better solution!
- V-lianl-msft
Community Support
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.
