Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
czuniga
Helper III
Helper III

Dynamic Conditional Formatting

I'm tring to add conditional colors to columns based on what's less than/greater than a dynamic parameter value. Any ideas on how to do it? Adding a column with dynamic values seemed promising, but I came up short on being able to implement it. TIA. 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@czuniga 

You can create a dynamic color measure. In place of static values, you can replace with value from the slicer

Color Date = if(FIRSTNONBLANK('Date'[date],TODAY()) <today(),"lightgreen","red")
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Date'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Date'[Year],2014)>2018,"red","yellow"))

 

Use fields option under conditional control and choose a measure like this. Refer :https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

 

View solution in original post

8 REPLIES 8
amitchandak
Super User
Super User

@czuniga 

You can create a dynamic color measure. In place of static values, you can replace with value from the slicer

Color Date = if(FIRSTNONBLANK('Date'[date],TODAY()) <today(),"lightgreen","red")
Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Date'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Date'[Year],2014)>2018,"red","yellow"))

 

Use fields option under conditional control and choose a measure like this. Refer :https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

 

Worked perfectly. Thank you!

@czuniga , please mark the solution that worked for you.

I feel like this is really close. What do I do with that measure in the context of needing to change the colors of the colums in this image based on the selection of the highlighted parameter? 80-20.jpg

@czuniga , have created a measure or used rule. If used measure shared calculation. else share rules,

Pragati11
Super User
Super User

Hi @czuniga ,

 

It will be really useful to have some form of screesnhots to your query or a .pbix file.

Currently, it's hard to understand and answer your question.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi Pragati, thanks for the response. I'm trying to conditionally format the colors of the these columns based on the selectio of the highlighted parameter. 80-20.jpg

nosaj03
Helper II
Helper II

@czuniga You can actually create a measure that does this. I actually had to do the same thing based on a rolling average. Check the links below

 

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

 

https://www.blue-granite.com/blog/controlling-conditional-formatting-using-dax

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.