DAX Conditional Formatting Trick

[@asadmahboob1123]

Wow...so a simple, quick and informative video.
Plz make a video on how to format the min (red) and max(green) value and be dynamic with Selectedvalues (the Outer filter)

[@veebee3969]

Thank you so much. Clear and precise explanations. I would like to ask a question please. In my bar chart, I was able to change bar colors based on (-), (+) values. However, the legend color remains the Power BI default color (i.e. the color that was there before applying the new measure). How can I fix it? Thank You in advance.

[@samanthafowler9054]

Love this!! Thanks. Trying to apply this, I am unsure of the DAX for my condition. I want red-green based on if the value increased (green) or decreased (red) based on the prior period and not formatting if equal to or no prior data. So, if my filter is set to month and I see jan =1, feb=3, mar=2 ------- jan = none, feb = green, mar = red. I hope this makes sense.

[@growlife4779]

how would you make this so colours change for the top 3 highest figures? so not necessary giving a threshold of 1.5 or 2.5m to account for cases where same column can have different amounts?

[@IvanCortinas_ES]

Great trick Chandeep! Thank you!

[@growupwithsatz1375]

Thanks for your video. I have one doubt, if we have multiple columns, then how can we apply condition formatting because it considers the overall average value while using measures. Can you please clarify this. Especially for this scenario where I have some data in a column based on date. It should change on a daily basis based on the last 7days average.Thanks

[@singhalmonica]

Can we do same with power pivot

[@YogeshKumar-pg3xz]

Thanks for the help but we we need to show the same in scroller visual it wont work.Please see if you help me any ways

[@tomgee4165]

Can you use the value of the dimension instead of a measure value? I simply want to have bubbles, bars, pie slices be red if color is red, yellow if yellow etc, but can't find a way to lock in the color assigned to the dimension

[@wayneedmondson1065]

Hi Chandeep. Cool trick! Thanks for sharing :)) Thumbs up!!

[@sharathacharya7016]

This is so cool. You again saved me. Brother.

[@GoodlyChandeep]

Glad I could help

[@giri41]

Hi
I would I get this , without applying conditional format on measure please.. just by DAX with if statement
If value >0 then Green else red .. just this

[@ashishmohan4707]

Hi Chandeep,
Happy birthday enjoy ur day.
God bless you.
💐🎂💐🎂💐🎂💐🎂💐🎂💐🎂💐🎂💐🎂💐🎂💐🎂

[@nhlanhlamakondo5474]

Thank you , this is so useful

[@hafizasim4245]

How to format using icons

[@timto3935]

Can you please make a youtube on how to use conditional formatting for changing the FAMILY FONT
in power BI. Thanks,

[@ramakumarguntamadugu1299]

very good useful trick👍

[@GoodlyChandeep]

Thanks it was useful Ramakumar!

[@gehnasharma5841]

this was super helpful

[@Renotalks]

Thanks bro, huge help

[@krishnawfx]

write dax if cell is blank then colour should be green in matrix

[@kartickshow]

Nice one

[@martyc5674]

Excellent

[@Rocks5033]

Thanks

[@GoodlyChandeep]

Welcome

[@pbihari0214]

thank you

[@Imrannaseem818]

Thanks paa gee