This is a great explanation of the idea. Here are some bonus tips: 1. Power BI supports 8-character RGBA (Red Green Blue Alpha) hex codes, so you can append a 00 to the end of the hex code to make formatted items transparent, FF to make them fully opaque (the default if omitted), or any value in between. This is a great way to make things appear, disappear, or fade based on any condition you can code in a measure. 2. You can add a color column to a dimension table to associate colors with a selected item by creating a measure that uses SELECTEDVALUE on that color column. I do this with brand colors sampled from the web, and it's a highly efficient way to color code a column chart (with brand on the x-axis) or a card value based on the associated company.

Bloody brilliant! AND, I'm happy to know that I'm not the only one that thinks the imbedded Conditional Formatting in Power BI is a pain. I will keep this video in my favourites and reference it often. Thank you!

I've used single measures for conditional formatting, but your combined measure if far superior! Thanks Wyn.

That's a great solution I have been looking for. I was searching for how to demonstrate the actual and budget comparison for the periods past so far. Thanks to your content, I will create a parameter that will highlight past periods with different colors. Regards. :)

I am a big fan of yours ...Like your tutorials

I'm glad you called out the Rules based formatting as being utter garbage.

Great explanation Wyn !!!

super clear explanation, one for my next db

Hi Wyn Thanks for a good explanation. Can you provide instruction on potential similar method when using a stacked bar chart where each "series" defined by the legend need to have a specific color? I'm looking for a method where lines in line chart, pies in pie char and bar in bar chart used the same specific colors for specific "series" defined in the legend throughout the report.

Great tip. I'm new to PowerBi and this was super simple to follow. One question: Given I have a lot of switch conditions (due to a lot of colours) - is there a way to get the measure to return a colour based on lookup from a table ?

This is a great suggestion. Really useful. I tried to create some kind of Income statement and colour the subtotals. But it does not work. I have the cf measure, I have the value measure (and if I put both in the value section the cf colour value is displayed as expected) but when entering the cf measure as background colour function ... nothing happens. Any idea why?

Thanks! Can you suggest a way to create a conditional formatting measure / rule without having to refer to a specific measure?

Ty Sir ! I have tried to replicate it on my end and i cant select the Cf measure as a conditional formatting independent of the visual i use. the measure is not grayed out , but when i select it nothing happens and i can't select it. any recommendations ?

I have this measure that returns text such as 50/12% BAC+ = IF([# BAC+]>0, FORMAT([# BAC+],"0") & "/" & FORMAT([% BAC+],"0%"),"") I want to conditionally format this measure using the following measure Met Bac+ target = IF( [bac+ target]