Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to change the color of a gauge embedded in a Table when a certain condition is satisfied?
As in the image below, i would like to make the Gauge color to red if [Change] is negative.
I have this formula inside gauge settings for color but it doesn't seem to work. Any help is appreciated. I also attached the sample app.
Calculated Color (inside Gauge Settings):
if ((Sum({$<[Report Date]={'3/31/2014'}>}[Equity Price]) - Sum({$<[Report Date]={'12/31/2013'}>}[Equity Price]))<0,rgb(255,0,0),rgb(0,0,255))
I think that is no possible because the values of each segment apply to all.
But in QV you never now... wait for a genius...
I think that is no possible because the values of each segment apply to all.
But in QV you never now... wait for a genius...
I suppose you can't change the color of the bar in a table
Just to add to the consensus, it is not possible. You can change the color of all the bars, but not based on the dimensions of the chart. All the bars either turn blue or all red, can't have them dynamically change based on their sum unfortunately.
Hope this helps!
Thanks all for the clarification.