excelpowerbidashboardkpi

Clustered Bar Chart with Two Colors

I want to create the below chart :

enter image description here

Expectation : I want to show the two colors like in above image. one for Actual Percentage and second for total ( like 100%).

My chart look like below :

enter image description here

How can I achieve this ?

Thanks

Solution

  • You need to create another value to add to your stacked chart. Just create another cell in your data, using a formula such as "=100-actual". The actual will be a reference to your cell with your value of 49.47.

    Then create a chart on both numbers. If you don't want the cell visible, just change the text to match your background.