Percentage

[Pavani]

Hi ,

When I done percentage normally it is showing correct percentage when I select top 5 death percentage I am getting diffrent percentage . Could you please check and suggest .

[aj1973]

Hi @Pavani 

That's normal, the pie chart gives you the percentage of each item inside the pie as a whole.

[Pavani]

Thank you!

If I required top5 countries what I need to give percentage .

[v-yueyunzh-msft · Accepted solution]

Hi , @Pavani 

 According to your description, you want to show top5 death in the pie chart and the percentage you want to show the same for the total death .

First of all, the percentage of Pie Chart is automatically calculated according to the value. If you want to modify the data label forcibly, you can use the new function dynamic measure of Desktop.

For this , you can refer to :
Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

 

And for your need , you can also refer to my steps:
This is my test data:

We can create these measures and i think some of them you have created in your side :

Total Death = CALCULATE( SUM('Table'[Death] ) , ALL('Table'))

Percentage = FORMAT( SUM('Table'[Death] )  /[Total Death] , "0.00%")

Measure 2 = SUM('Table'[Death])

 

Then we can put the Measure 2 as the value in the pie chart and we open the "Dynamic" for the [Measure 2 ]:

And then we put this in it:

""""& FORMAT(SUM('Table'[Death]),"0") &  "(" & [Percentage] & ")"

 

The result as follows:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly