Forum Discussion

community_pinki's avatar
community_pinki
Helper II
4 years ago
Solved

TopN+Others using Pie chart

Hi All, I have a Pie chart where each sub-category contributing to the total sales. Now, I have a requirement that the pie chart should show only top 5 sub-category and remaining should be in Other...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi community_pinki 

    I think you can build a calculated column by DAX to show new subcategorys with Top5 and Others.

    My Sample:

    Top5 Flag is a calculated column.

    Top5Flag =
VAR _Rank =
    RANKX (
        'Table',
        CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER ( 'Table', 'Table'[SubCategory] = EARLIER ( 'Table'[SubCategory] ) )
        ),
        ,
        DESC,
        DENSE
    )
RETURN
    IF ( _Rank <= 5, 'Table'[SubCategory], "Others" )

    Result:

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

 I am getting an error, saying SUM function cannot work with STRING. Please guide me. I am looking for the same soluction.

 

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    What is the type of data you are using? Do you want to make a sum of a field? A count?