Forum Discussion
Community Championconditional format horizontal bar chart with one data point (no y-axis)
Good Afternoon,
I am using a horizontal bar chart visual with one data point that displays a Measure in Minutes.
Hoping someone can advise how I can conditionally format the color of the bar. Less than 30 = green, 30 - 45 = yellow, etc..
It seems I can only get the conditional format option when I enter a field into the y-axis. But this measure does not have an applicable axis. What am I missing?
Thanks and regards,
5 Replies
PaulDBrownHere is one (laborious...) way:
In the following example, I have set the low limit at 100 and the medium limit at 200:
For a simple sum, I created the following measures:
1) Low threshold:
Low = VAR low = 100 RETURN IF([Sum Value] > low, low, [Sum Value])2) medium threshold
Medium = VAR Med = 200 RETURN SWITCH(TRUE(), [Sum Value] > [Low] && [Sum Value] < Med, [Sum Value] - [Low], [Sum Value] >= Med, 100 )3) High Threshold
High = IF([Sum Value] > 200, [Sum Value] -200)The I add these three measures to a stacked bar chart, where you can set the colour for each measure, to get this
Add the measure as a tooltip:
- rsbin
Hello PaulDBrown ,
Does sound like a very laborious way to accomplish this. I will try to give it a shot to see if this will work for me and my user group. Appreciate the detailed response.
Thanks kindly,
- PaulDBrown
Apologies..there is a mistake in the Medium threshold measure. It should be:
Medium = VAR Med = 200 RETURN SWITCH(TRUE(), [Sum Value] > [Low] && [Sum Value] < Med, [Sum Value] - [Low], [Sum Value] >= Med, 100 )(otherwise, since it is stacked, it adds 200 to the bar, when low + Med = 200)
I've corrected it in the original reply for the benefit of others.
- rsbin
Hi Anonymous, Appreciate the prompt response.
The fx is not available when I have only one data point. This is what is causing me much grief!
Is there a workaround to this? Or am I totally missing something?
