Forum Discussion
Easy Conditional Text based on column values
Hi PowerrrBrrr ,
Here are the steps you can follow：
1. Create measure.
color = IF( MAX('Table'[Value])=0,"red","green" )status = IF( MAX('Table'[Value])=0,"Inactive","Running")2. Select Format – Conditional formatting – Machines – Background color.
3. Enter the Background color interface.
Format by – Field value
Based on field – [color]
4. Result:
Does this match your expected result?
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
But here you are putting Machine 3 as Red and Inactive in your Formulae. In my case it can be any machine.. Machine 3 I gave as an example
HI PowerrrBrrr ,
In that case you need to write a set of rules for me to create a measure. 🙂
You can even modify the above measures based on your requirement.
Also, I don't understand what do you mean by - any machine. Do you want your Machine column value coming from a slicer or how you want it to be?
Thanks,
Pragati
I gave the rule it is when Value is 0. I dont see anywhere in your DAX that you are checking this condition. you are simply selecting the Machine column and for machine 3 you are putting it as RED. We need to have condition to set it as red when value is 0 and that I have already done with conditional formatting. I am now looking to get conditional text based on value
HI PowerrrBrrr ,
I would have liked your description to be consistent when you provided me with the sample data. 🙂
Anyways, going with your above description - I am now looking to get conditional text based on value
To get dynamic text based on your Value column, just modify the 2nd DAX that I have shared to use your Value column rather than Machine column.
conditionalStatus = var t1 = SELECTEDVALUE(conditionalData[Value]) RETURN SWITCH( TRUE(), t1 = 0, "Inactive", "Running" )Thanks,
Pragati