how to present data as Percent of grand total(near cathegory description)?

[Jolyon]

Hello,

could someone help me please with my question?

I have vizualized my data in a diagramm as here in the example, but I need to present the numbers  in percents of grand total (near cathegory descriptions) , i.d. Bikes(2%), Auto(3%), Tracks(88%) etc. Is there some function in Power BI for presenting the percents near description?

Any idea?

Thanks a lot!!

[Vvelarde · Accepted solution]

hi @Jolyon

you can do it this with Quick Calc in the column in Values

[Jolyon]

thanks @Vvelarde!

that was exactly what I looked for)

regards,

Jolyon

[v-qiuyu-msft]

Hi @Jolyon,

It seems that you are using a pie chart visual to display the data, right?

In your scenario, you can create a measure to return the percentage value for each category, then place this measure in chart Values property. Change Label Style as Both. See:

percentage = DIVIDE(SUM(DimSalesTerritory[SalesTerritoryKey]),CALCULATE(SUM(DimSalesTerritory[SalesTerritoryKey]),ALL(DimSalesTerritory)))

Best Regards,
Qiuyun Yu