Forum Discussion
Balogh1Bence
2 years agoHelper II
conditional formatting as string instead of color
hi! I found a nice guide to create conditional formatting. https://learn.microsoft.com/en-us/power-bi/developer/visuals/conditional-format?tabs=enumerateObjectInstances However, this shows only t...
Anonymous
2 years agoNot applicable
Hi Balogh1Bence
Create a Calculated Column: Create a new calculated column in your data model that contains the string values you want to use for conditional formatting. You can use DAX (Data Analysis Expressions) to create this calculated column.
For example - StatusText =
IF([Sales] > 1000, "High", IF([Sales] > 500, "Medium", "Low"))
Use the calculated column (StatusText in this example) instead of the original numeric or date column. You can display this column as-is without any further conditional formatting.
This approach allows you to display strings based on conditions, but it's not dynamic conditional formatting in the sense of changing the appearance of visual elements based on conditions.