Forum Discussion

Balhemkan's avatar
Balhemkan
Icon for Helper III rankHelper III
5 years ago
Solved

Pie chart with others

Hello Team,   I am facing difficulty to achieve one requirement. I am using pie chart  in powerbi In that I am pulling two columns Country Sales India 900 Srilanka 500 German...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

jaideepnema's avatar
jaideepnema
Icon for Solution Sage rankSolution Sage
5 years ago

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())
 
and then use these two columns like this to create the pie chart

 

Here is the pbix in case required
 
Please accept this as a solution if your query has been answered !!
Appreciate a Kudos ðŸ˜€

 

  • Balhemkan's avatar
    Balhemkan
    Icon for Helper III rankHelper III
    5 years ago

    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's avatar
      VijayP
      Icon for Community Champion rankCommunity Champion
      5 years ago

      Balhemkan 

      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!