Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditionally format bar chart based on another field value

Hi   Does anyone have a way to conditionally format bar chart columns based on another fields value?   I would like the colours to be Red and Green based on whether the sum is greater than a targ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi Anonymous 

     

    Download example PBIX file

     

    You need to create a measure that sets a color value based on the Target value, presumably this is a measure.

    With that done, you can use the new color measure to set conditional formatting on the columns/bars

     

    Measure to set color based on target value. I'm using Hex color codes, #0F0 is green, #F00 is red.

     

    Column Color = IF(SUM('DataTable'[Value]) >= [Target], "#0F0", "#F00")

     

     

     

    Then apply a CF rule

     

     

     

     

    Regards

     

    Phil

     

OneHotEncoder's avatar
OneHotEncoder
Frequent Visitor
2 years ago

Hi all,

 

Thanks for the discussion and the answer to this topic.

I'm currently trying to do a conditional formatting for a similiar use-case.

I have two bars in a clustered column chart, first is the achieved number, 2nd bar is the target number.

I would like to add the following conditional formatting: if the achieved number is smaller than the target number, the achieved number bar should be red. Otherwise, the achieved target number bar will be green.

Both bars should be visible in the clustered column chart.

 

I setup the measure which does exactly this:

Achieved number Color = IF('Sheet1'[number_achieved] >= [Sheet1], "#0F0", "#F00")
 
The issue with your solution is that once I add the 2nd bar to the clustered column chart, it does not work anymore.
The conditonal formatting for the achieved bars vanish once adding the target bars..
 
Is there any solution to this?
  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    2 years ago

    Hi OneHotEncoder 

     

    If you can starrt a new topic and attach your PBIX file that'll make it easier to help you.

     

    Regards

     

    Phil