Forum Discussion

TineM's avatar
TineM
Regular Visitor
1 year ago
Solved

Bar chart conditional formatting without fx

Hi Experts, I would like to compare two weights, left target weight and right actual weight. I would like to show the bar red if the actual weight is higher than the target. The fx button is not av...
  • danextian's avatar
    1 year ago

    Hi TineM 

     

    You will need to create two separate measures that return a value based on whether the actual is greater than or equal to the target, or otherwise. Use these measures in your visual, as conditional formatting on bar or column charts with a legend value is currently not supported.

     

    Note:  I used the native bar chart in the screenshot below which doesn't seem to look like th one in your screenshot

    Please see the attached sample pbix.