cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rsbin
Post Patron
Post Patron

conditional 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.

rsbin_0-1614452071095.png

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 5
PaulDBrown
Super User II
Super User II

@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

result.JPG

Add the measure as a tooltip:

Tooltip.png

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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,

@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.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






pranit828
Super User II
Super User II

Hi @rsbin 

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

pranit828_0-1614453296071.png

 




PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile

Hi @pranit828,  Appreciate the prompt response.

The fx is not available when I have only one data point.  This is what is causing me much grief!

rsbin_0-1614453489963.png

Is there a workaround to this?  Or am I totally missing something?

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors