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.
Good Morning Folks,
I'm stuck in that I want to have my pie chart show visually only the "Top 5" but keep the precentages of all items in that column. My visual is counting a single column of Text. What I would like is for visual below with TOP 5 have the over all percentages, knowing that it won't add up to 100%.
I've tried to use the built in "% of grand total" function on the visual drop downs. That did not work because once you filter it to "top 5" that top five becomes 100%.
I'm doing this for the Question "what are your top five templates used weekly"?
Correct Percentage
Correct Visual
Hi @Almercie,
Do these two images show the correct result? If so, please download the solution from the attachment.
1. Create a column in the table to show up "top 5".
2. Add the new column in a slicer.
Best Regards,
Dale
Hi @Almercie,
How about this workaround? Showing others as one and still keeping the percentage.
ifTop5 = VAR ranks = RANKX ( ALL ( DimProduct[ColorName] ), CALCULATE ( SUM ( Sales[SalesQuantity] ), ALLEXCEPT ( DimProduct, DimProduct[ColorName] ) ) ) RETURN IF ( ranks <= 5, [ColorName], "others" )
Best Regards,
Dale
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |