Forum Discussion

Anonymous

Not applicable

4 years ago

Condtional Formatting Issue

Why does Power BI not let me conditional format something? It blurs out the metric I want to conditionally format.

Tips and Tricks

Super User

4 years ago

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

Anonymous
Not applicable
4 years ago
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
- TomMartens
  Super User
  4 years ago
  Hey Anonymous ,
  
  this converts a text like "h:mm:ss" into a decimal of datatype DOUBLE:
  
  Time to Decimal = Convert( TIMEVALUE("0:15:00") , DOUBLE )
  
  Regards,
  
  Tom
  - Anonymous
    Not applicable
    4 years ago
    Hi TomMartens So I input that as the calculation and it made every value as 0.01
    
    However if it is going to make every value as a decimal, is it impossible to conditionally format the way I would like it to be?