cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Almercie Frequent Visitor
Frequent Visitor

Pie Chart to use % of grand total.

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 Percentage


Correct Visual Correct Visual


3 REPLIES 3
v-jiascu-msft Super Contributor
Super Contributor

Re: Pie Chart to use % of grand total.

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. 

Pie-Chart-to-use-of-grand-total

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Almercie Frequent Visitor
Frequent Visitor

Re: Pie Chart to use % of grand total.

Unfortunately this will still give me a total of 100% and effectively a toggle switch of "all items or Top 5 items". I'll need the visual to only display the five largest represented items of the column and what percent of the Over All total it is. My work around is to put this in a visual table and hide anything that is lower than row 5.
v-jiascu-msft Super Contributor
Super Contributor

Re: Pie Chart to use % of grand total.

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" )

Pie-Chart-to-use-of-grand-total2

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 43 members 906 guests
Please welcome our newest community members: