conditional format horizontal bar chart with one data point (no y-axis)

[rsbin]

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,

[PaulDBrown]

@rsbin 

Here 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]

@rsbin 

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.

[Anonymous]

Hi @rsbin 

You can use the Data Colors in the format tab to conditionally color.

[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?