Bar charts filled with percentage

[Newbe123]

Hello dear community,

I am trying to colour-fill my bar charts based on a percentage. The bars represents a duration, the percentage is the completion of the work done (within this duration). I am aware of the conditional formatting, but hope there is a quicker solution to fill the bars instead of creating 100 rules. 

An example of what I would expect below (created in ppt). 

Anyone who could help me here? 

Kind regards,

Newbe123

[v-xinruzhu-msft]

Hi @Newbe123 

You can use 100% stacked bar chart

e.g Sample data

Then put the field to the visual

Then set the color of the bar

Best Regards!

Yolo Zhu

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