Conditional format data bar - bar covers full range even when in percentage is less than 100%

[casperjbfc]

I have applied a measure for %Complete (= [_EV] / [_EV]. It gives me the correct percentage value, but when i turn the conditional formatting data bar on, the highest value (22%) measures 100% of the data bar.

How do i get the data bar to only fill 22% of the cell size?

[v-lid-msft]

Hi @casperjbfc ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @casperjbfc ,

We can try to change the range of  the bar from 0 to 1 to meet your requirement:

If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.

Best regards,

[Anonymous]

Fantastic. Works like a charm.

[amitchandak]

Can you share the Conditions and, what is expected max value