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

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

Hi manju_yadav ,


Does this issue have been resolved?Could you please provide more details about it If it still not be resolved, Such as the screenshot of condition format and the formula of measure you used? Please don't contain any Confidential Information or Real data in your reply.

 


Best regards,

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,