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

Hi!

 

You can create a measure assigning the different colors such as the following

 SWITCH (
    TRUE (),
    ISBLANK ( [Projected Active Users % of Target YTD] ), "#FFFFFF00",
    [Projected Active Users % of Target YTD] < .9, "#FF0000",
    [Projected Active Users % of Target YTD] < 1, "#FFFF00",
    [Projected Active Users % of Target YTD] < 1.25, "#00CC00",
    [Projected Active Users % of Target YTD] >= 1.25, "#0099FF",
    BLANK ()
)

 and then apply it as conditional formatting.

 

https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting

andrew5083's avatar
andrew5083
Frequent Visitor
5 years ago

littlemojopuppy unfortunantely this doesn't work either.  I attempted this when creating a 'color measure' as referenced in my original post.  However, if there are >1 bar in a bar chart the option to conditionally format any color does not appear.  

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