Applying custom conditional formatting using a Measure in Power BI

[@jazzista1967]

Great Trick Rick! Like that idea of putting a measure as conditional formatting in top of another measure. I will try this at work today. Thanks for posting. And yes, post some more Powerquery and DAX tricks. This was extremely useful. Happy new Year!

[@BIGorilla]

This was an actual case my client had. After knowing this you can get very creative. And I will keep posting stuff Jazz, I have some more ideas in mind, will be posted soon! 🚀

[@sarabashi1269]

YOU SAVE MY TIME. THANK YOU

[@monicakim777]

This is super helpful thank you!

[@SunilKumarMutte]

Thanks, its a great tip however I would like to know how to compare 1-Jan vs 1-Feb or 1-Feb vs 1-Mar, whether value is increased or decreased

[@ebogart42]

great information - THANK YOU!

[@Montreal_powerbi_connect]

Hello, thanks for good tip, some custom visuals doesn't have conditional formatting, how can I add it to my visual ?

[@BIGorilla]

Some visuals don't support it im afraid. The visual will show the options when it's available. Who knows they may support it in the future! Cheers Rick

[@Montreal_powerbi_connect]

@@BIGorilla thanks for your replay.

[@kevinmcq7968]

this is amazing, thank you

[@АртемШибанов-е3т]

Nice trick, very usefull. thanks for good explaining.

[@BIGorilla]

Thank you!! Enjoy

[@josemarquez3885]

Hello! Is there a way to conditional formatting a column inside a matrix that comes from an unpivot column, I try this rule but it doesn't work properly: Rule = IF(MAX('Backlogs list testing'[Month])="06 June OA vs Actuals",0 I need to apply the conditional formatting to just one column. Thanks in advance.

[@oneallwyn]

Wow, that was so awesome... you are subscribed

[@BIGorilla]

Thanks Allwyn. Powerful stuff!

[@siphesihleyapi4102]

How do i compare adjacent columns in a matrix; if column 1 > column 2 then show down error icon?

[@BIGorilla]

Depends what you put in the columns. If its months. You can change the filter context to generate the earlier cells

[@hamzamottali3567]

Hello , thank you for your efforts, please I have a question about tables ..can I make condition date formula or some rules in order to change the rows color in terms of what I want ? is there any way to cotrole the row color by condition date ? i know that you can change the row color but not by a condition that you made. for example if date A < date B make the row in red color etc ... thank you for your help

[@BIGorilla]

I believe it's possible. The logic should be in the measure. So you can Base the conditional formatting on the measure. Do you have a sample file to work with?

[@hamzamottali3567]

@@BIGorilla yes i have but how can I send it for you ? is there any address email or some thing like that ?

[@BIGorilla]

@@hamzamottali3567 If you like, you can share it at [e-mail]. Please indicate your desired outcomes :)

[@hamzamottali3567]

@@BIGorilla Absolutly i will do that Thank you 🙂

[@mitalia38]

@@BIGorilla Was there a solution here? I would like to utilize for a forecast waterfall report.

[@zzzzzzzzzzzzzzzz9]

Im new here.

[@BIGorilla]

Welcome to the Channel!