Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Colors for Bar Chart Visualization

Hi,

 

I'd like to create a Bar Chart Visualization that is dynamic.  I'd like the bar values to change color if the value is above a specific value.

 

I've done this in the past using the Analytics Tab and created a Constant Line.  Here is an example of this.  When the bar value are above .05% the bars turn Red, otherwise they remain Green.

 

 

However, I need to make this visualization more dynamic.  I'd like the constant line value to be dependant on a slicer selection:

 

 

Essentially, when the user makes a selection in that slicer, I need the constant line to update according to the value associated with the group.  For example:

 

Group      Value

A              .05% 

B              .07%

C              .02%

 

I tried creating a table like the dummy data above and created realtionships but Constant Lines need to be manually set.  I don't believe they can reference a Measure or Custom Column. 

 

I also tried using a Bar and Line Chart visualization.  While that allowed me to create a horizontal line that matches the Groups Value...I don't know how to make the color of the Bars dynamic....meaning have them change color if the bar is above the line value.

 

Does any of this make sense?  I'm closely monitoring the thread so if you have any questions I will answer them quickly!

 

 

 

Thank you!

Andrew

2 Replies