Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |