Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    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's avatar
v-frfei-msft
Community Support
8 years ago

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's avatar
v-frfei-msft
Community Support
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

     

    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.