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
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.
Solved! Go to Solution.
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
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?
@czuniga , have created a measure or used rule. If used measure shared calculation. else share rules,
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
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.
@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
User | Count |
---|---|
160 | |
110 | |
96 | |
86 | |
75 |
User | Count |
---|---|
159 | |
136 | |
133 | |
81 | |
61 |