2 Replies Latest reply on Apr 22, 2013 10:43 PM by Colin Macguire

    Conditionally format colour of Bar Chart based on another measure

    Colin Macguire

      Good morning,


      I have two measures that I need to display on a bar graph. The one measure being displayed as a bar (which is the actual value), & the other being displayed as a line over time (which is a target that the actual measure is measured against). What I need to do is change the colour of the bar graph if it's value is less than ( < ) the value of the other measure. I basically want an easily visualized way of showing whether or not a value is above or below a target. This would be similar to what can be done in MS Excel in terms of conditionally formatting a cell based on a value or on another cell.


      I am currently using another tool that can do this quite easily using alerts (the chart is based off of a pivot table) & wanted to see if this can be done in Tableau. Attached is the screenshot of what it looks like in my current tool.


      Looking forward to hearing from you.