Use Conditional Formatting to format another column in Power BI

Did you know you could use conditional formatting to format one column by another in Power BI? Patrick shows you how!

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

*******************

********
LET'S CONNECT!
********

***Gear***

#PowerBi #ConditionalFormatting #GuyInACube

[alvinwiyanto]

Hi Patrick/Adam. I've been watching lots of videos from your channel and it's really a game changer in my workplace! Keep up the good work and thanks for sharing.

[budgetdust]

Patrick, I like the shout out to LSU in the background. I think that's new? Congrats to your Tigers on the National Championship. I'm an Aggie, but total props. Your team crushed everyone...oh yeah, and great Power BI content too.

[mcsespitia]

I create a measurement to calculate KPI scores then use the conditional formatting and use icons. I do like this as well and might use it for work order status for past due vs in progress and on time

[j.carlostaveracantera]

Good morning, thank you very much Patrick! Excellent contribution and very useful, I follow it with great attention. Excellent day

[sqldevdba]

Awesome video!! We actually did this using direct query. We created a column in the SQL server view that determines the color of the field, and made the output of that column text (with Hex values like Then we just used your same functionality but didn’t have to create any measures at the PBI level.

Thanks for sharing!

[aahnajaiswal]

Hi, I have a requirement, please help.
I have a matrix visual with 8 measures and all are formatted using conditional formatting. so I want to count the cells with each color on that chart, for eg count of amber/red/green of those cells.
Please suggest.

[dawnjums]

hi,
please I have an issue with matrix visual. the color conditional formatting will not show the right colors for opportunity status won, lost and open, the respective colors are green, red and yellow,
however it will show the right colors if i include the opportunity id in the rows

which i dont want consumers to see, how can i handle that?

[NEWZY]

I m Fan !!! Your energy is so !!! You are amazing teacher !!!!

[blumeiblumeirelax]

Hi Patrick/Adam, I am learning a lot from your videos. Your videos are having extensive information and understanding.

Keep up the good work. Thanks for sharing . Love from #India .

[anilgavhane]

Hey Patrick, how can we get Same GUI while modifying custom column (Using if else logic) as per my knowledge the if we create custom column using if else conditions and save it. when we try to modify it and use "AND" we cannot proceed as "AND" is not supported in conditional columns, is there any other way to get custom columns GUI.

[reanalytics]

Hi Patrick
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]<1,
"",
IF(
[% BAC+] < [bac+ target] * [lower bound],
"#FF4136", -- Target Not Met
IF(
[% BAC+] < [bac+ target]*[middle bound],
"#FF8F00", -- Close to Target
"#2E7D32" -- Target Met
)
)
)

however, Power BI does format the text values, what am I doing wrong in this case?

Thank you for all your education

[dhunusarma]

I have a complex problem in power BI. I need to compare between two measures a and b, and if a>b then green else red. But this should change dynamically when you select a region. Region would be there in a slicer. Would you please help to solve this issue?

[jithinrg]

Hey Patrick, It is a nice tweak while using the table viz's conditional formatting, we have only limited colors to show.
I have another requirement to use diverging colors to the table's conditional formatting data bars (not in Format section). Is there any idea to implement it?

[ThegracesOfFaith]

Thank you Patrick for the trick but I do have one question, what if you instead want to dynamically change background color of the column headers based on the slicer selection. Is that possible?

[kishoreo]

Awesome teaching and easy to understand ...thank for all the videos...
Quick question: We can do same conditional flitering on the format by rules and mention all the required conditions but you have used separate table to format it..what would be the best way to do either on report or data modelling?

[koutlaw]

Patrick, I finally figured it out. Thanks so much!!!

[alex]

Great Video. Slightly different spin on it. I have a column (Corp Average) and another column (Group Total). I want to conditionally format the group total to show green (lower than corp average), red (over corp average). I dont want to have the "diff" measure in the table though. Any ideas?

[JayFrVz]

Many thanks for your work! I'm looking forward to learn the same stuff for slicers. This way, I could use them as slicers and legends.

[ricogustomb]

THANKS a lot for this video. Best explanation so far about this and so simple. Many thanks.

[ershelin]

Thanks so much. simple but very useful