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...
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
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.