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

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?
  - TomMartens
    Super User
    4 years ago
    Hey Anonymous ,
    
    consider creating a pbix that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive or dropbox and share the link. If you are using Excel as a data source instead of using the manual input method, share the xlsx as well.
    
    Describe the expected result based on the sample data you provided.
    
    Regards,
    
    Tom