Forum Discussion
Missing Data Bars
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
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
3 Replies
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
Hi Anonymous,
Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.
Regards,
Frank