Forum Discussion
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...
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
resultPat
I tried the suggested solution, it didn't work - back to square one.