Forum Discussion
Condtional Formatting Issue
Why does Power BI not let me conditional format something? It blurs out the metric I want to conditionally format.
Hey Anonymous ,
this part of the measure
...
FORMAT(hours, "0") & ":"
& FORMAT(minutes, "00") & ":"
& FORMAT(seconds, "00")Turns the result into a string for this reason you can't the measue to trigger conditional formatting.
You can do the following, create a second measure that represents the time value as a decimal.
Then you can use Conditional formatting based on Rules:
Select the measure that represents the time as a decimal value and create formatting rules accordingly.
Hopefully, this provides what you are looking for and helps to tackle your challenge.
Regards,
Tom
So the format is a text. Still makes sense a little why I am unable to conditionally format. What sort of DAX Expression would make it a decimal? Because it should be formatted as "0:00:00"