Forum Discussion

Nikita_SK's avatar
Nikita_SK
New Member
4 years ago
Solved

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 sh...
Donut chart
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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.

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

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.