Missing Data Bars

[Anonymous]

Hello,

I am trying to add a data bar to my table. It is a measure calcuating  completion percent (number is a decimal formated in percentage). However, data bar is not a option in the conditional formatting field. Anyone know why that would be?

Thanks,

Brian

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Based on my test, everything goes well by this way. Here I create a measure like this and change its format to Percentage as the picture below.

Measure = SUM(Table1[sale])/SUM(Table1[amount])

If you create a measure like this.

Measure2 = FORMAT(SUM(Table1[sale])/SUM(Table1[amount]),"0.00%")

Then the data bars will missing. So kindly use the first way and try again.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/1mj75n0hpjm1k6c/Missing%20Data%20Bars.pbix?dl=0

Regards,

Frank

[v-frfei-msft]

Hi @Anonymous,

Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.

Regards,
Frank

[Anonymous]

This is the formula that I am using. I am not formating anything and using numbers. The result is s a decimal number. Still no data bars.