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 ,
you need two measures one that formats the value to your liking "0:00:00" (the string).
Then create a 2nd measure that converts the text value into a decimal (Solved: DAX function HH:MM:SS to Decimal Format - Microsoft Power BI Community). Then use the 2nd measure to add conditional formatting to the first measure.
Regards,
Tom
Hi! TomMartens
So I did
= FORMAT('CallData'[AvgTalkTime(Mins)], "Decimal Number")
And it stayed the exact same as Text and blurs out the 2nd measure for conditional formatting