Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 table is called CoolSports
Here's the data in my table:
CATEGORY | ROW_COUNT | RANK |
WaterSki | 812 | 1 |
SnowSki | 727 | 2 |
Biking | 699 | 3 |
Mountain_Bike | 547 | 4 |
Swim | 358 | 5 |
Hiking | 210 | 6 |
Telemark | 175 | 7 |
Walk | 50 | 8 |
Jog | 23 | 9 |
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I tried the suggested solution, it didn't work - back to square one.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |