Forum Discussion

Helper II

3 years ago

Solved

Percentage

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 .

Need Help

Tips and Tricks

v-yueyunzh-msft
3 years ago
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

20230726data label.pbix26 KB

Pavani

Helper II

3 years ago

Thank you!

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

v-yueyunzh-msft

Community Support

3 years ago

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

20230726data label.pbix26 KB

Forum Discussion

Percentage

Related content

Percentage by group

Converting to Percentage

Percentage Formatting

Categorise average percentages

Need help getting a percentage change working