Forum Discussion

manju_yadav's avatar
manju_yadav
Regular Visitor
6 years ago
Solved

Conditional Formatting on Bar chart

I want to colour code my bar chart based on %value on my measure like if % <50 then Red when % between 50-90 then yellow and above 90 green. Used conditional formating option on Data colour Card. wor...
Need Help
Tutorial Requests
  • manju_yadav's avatar
    manju_yadav
    6 years ago

    Thanks for reaching out,

     

    yes this been resolved, I used number instead of % for my conditioning formating and it worked, but I wonder why I was not able to do this with % ,when my measure was like numerator/Denominator  and formated this as %.

manju_yadav's avatar
manju_yadav
Regular Visitor
6 years ago

Thanks for reaching out,

 

yes this been resolved, I used number instead of % for my conditioning formating and it worked, but I wonder why I was not able to do this with % ,when my measure was like numerator/Denominator  and formated this as %.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi manju_yadav ,

 

Because when using percent  in rules of conditional format, it means percent of biggest value, such as in  second screenshot, when using number, the 90% means 90%, but when using percent as rules, it means 90%/1500%=6%, and 90%/90%=100% in first screenshot.

 

 


By the way, PBIX file as attached.


Best regards,