Need help to create multilayer donut chart

[ritendersingh2]

Hello ,

I need help creating a multi-layer donut chart with the following specifications:

• Inner Layer: Represents the actual numbers.
• Outer Layer: Represents colors based on the outcome (Red, Green, Yellow).

The logic for the colors is as follows:

• Green: If the goal is higher than actual
• Red: goal is lower than actual.
• Yellow: If the actual number is in between the high and low thresholds.

I have data for both the actual values and goals, and I'd like the outer layer to display only the respective color based on the comparison outcome.

Looking forward to your suggestions!

Attaching the sample report Sample Report , please help

[v-jialongy-msft · Accepted solution]

Hi @ritendersingh2 

Power BI's built-in visuals might not meet your needs, so you can try using custom visuals to implement them.

Best Regards,

Jayleny

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