Forum Discussion

ScotchCat's avatar
ScotchCat
Regular Visitor
5 years ago
Solved

Help! Top 5 and Others

Help! I will need to create a pie chart that shows the top 5 by Rank (1-5) and group all the rest (Rank 6-9) into an 'Other' category.  I'm pretty new at this - be gentle!  Thanks in advance!    My...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can do this with the Charticulator visual.  See example below.  The key is to make a measure like the one below along with the Category and Row Count columns in your visual, and then Group By the new measure and make it a radial scaffold.

    (3) Charticulator: Now a Power BI Custom Visual! (with Daniel Marsh-Patrick) - YouTube

     

     

    Top5 =
    VAR top5 =
        TOPN (
            5,
            ALLSELECTED ( CategoryRank[CATEGORY] ),
            CALCULATE ( SUM ( CategoryRank[ROW_COUNT] ) ), DESC
        )
    VAR thiscategory =
        SELECTEDVALUE ( CategoryRank[CATEGORY] )
    VAR result =
        IF ( thiscategory IN top5, thiscategory, "Others" )
    RETURN
        result

     

     

    Pat

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

You can do this with the Charticulator visual.  See example below.  The key is to make a measure like the one below along with the Category and Row Count columns in your visual, and then Group By the new measure and make it a radial scaffold.

(3) Charticulator: Now a Power BI Custom Visual! (with Daniel Marsh-Patrick) - YouTube

 

 

Top5 =
VAR top5 =
    TOPN (
        5,
        ALLSELECTED ( CategoryRank[CATEGORY] ),
        CALCULATE ( SUM ( CategoryRank[ROW_COUNT] ) ), DESC
    )
VAR thiscategory =
    SELECTEDVALUE ( CategoryRank[CATEGORY] )
VAR result =
    IF ( thiscategory IN top5, thiscategory, "Others" )
RETURN
    result

 

 

Pat