Forum Discussion
Donut chart
I am using Donut chart to show exceptions based on duplicates for 3 parameters...for which the totak must be total vendors...However in Donut chart or Pie chart it is taking 100 as denominator for showing the percentage...How do I change the total value
Hi Nikita_SK ,
For dynamic percentage changes, try using the ALLSELECTED function to demonstrate this, which will dynamically change its total value based on your parameters or other filters. Refer to the contents of a screenshot similar to the following.
dynamic% = VAR TotalAmountByColor = CALCULATE ( [Amount], ALLSELECTED ( DimProduct[Color] ) ) RETURN DIVIDE ( [Amount], TotalAmountByColor, BLANK () )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Donut charts can be frustrating to design and format. For anyone interested, we built some basic tips for building donut charts and have example Power BI donut charts for inspiration. Numerro visualizations and templates have some dummy data so you can see how they work and repurpose them for your own use.
Hi Nikita_SK ,
For dynamic percentage changes, try using the ALLSELECTED function to demonstrate this, which will dynamically change its total value based on your parameters or other filters. Refer to the contents of a screenshot similar to the following.
dynamic% = VAR TotalAmountByColor = CALCULATE ( [Amount], ALLSELECTED ( DimProduct[Color] ) ) RETURN DIVIDE ( [Amount], TotalAmountByColor, BLANK () )
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
