Forum Discussion

andrew5083's avatar
andrew5083
Frequent Visitor
5 years ago
Solved

Coniditionally Format Color on Clustered Bar Charts

I'm brand new to Power BI.  We're comparing Power BI's capabilities to our current BI software to see if it may be a viable replacement.  In our current software, it is extremely simple to create cus...
Need Help
littlemojopuppy's avatar
littlemojopuppy
Community Champion
5 years ago

It does work if you define the measure properly...have done it in a number of projects I've worked on

andrew5083's avatar
andrew5083
Frequent Visitor
5 years ago

I'm not sure how else to define this measure properly.  Here is a simple if statement I've used to set the color based on pos or neg values.

 

As you can see in the picture, there are no options to conditionally format the color of any column in that bar chart.

 

If I add the created "Conditional Format" measure to the analysis, it only allows it to be added to the Tooltip section and still, no options to conditionally format any value colors appear.

 

Are you able to access the menu to apply conditional formatting to a bar chart with 2 or more values being represented as bars?

 

As I mentioned in my original post, the conditional formatting menu is available when a bar chart contains just 1 bar as shown below.  I can then use the created 'color measure' to color the bars.  However, this limitation does not create useful analyses for our user base.  

 

 

I'm wanting to see if something has been overlooked, or if this basic functionality is still not avaialble in Power BI.