Power BI Conditional formatting using Measures 

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'm glad you called out the Rules based formatting as being utter garbage.

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.

Awesome✨. Thanks for sharing. Just one question - I need to format 15 measures with the same ranges. Is it possible to create one dax cf-measure and use it for formatting multiple measures or I have to create 15 cf -measures?

Hi and thanks for a great tutorial! What is the correct way to add more number intervals and thus colors to this measure?

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

Great tool! I'm using this to highlight errors vs threshold. In my application, if errors exceed threshold, then highlighted red (out of spec). Some errors do not have thresholds, so these should not be highlighted. What can I add so these fields are not formatted?

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. :)

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 ?

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]

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

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?

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

super clear explanation, one for my next db

Great explanation Wyn !!!

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 ?