Solved: Re: Conditional formatting

Anonymous · ‎09-13-2021

Hi all,

Hope someone can help me with the following.

Below is a simple table.

What I want is the following;

If the TIME_TO_COMPLETE is more than 00:20 and the MODALITY_OUT is TRUCK, the time to complete value must shown up in YELLOW.

Is there a formula to do so?

Thanks for your help!

John

amitchandak · ‎09-13-2021

@Anonymous , hope time complete is a measure the color measure

if( [TIME_TO_COMPLET] >= time(0,0,20) && [MODALITY_OUT] = "TRUCK" , "Yellow", "White")

Use in conditional formatting using field value option

[TIME_TO_COMPLET] >= 20 // if time in second and formatted as time

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎09-13-2021

@Anonymous , hope time complete is a measure the color measure

if( [TIME_TO_COMPLET] >= time(0,0,20) && [MODALITY_OUT] = "TRUCK" , "Yellow", "White")

Use in conditional formatting using field value option

[TIME_TO_COMPLET] >= 20 // if time in second and formatted as time

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Anonymous · ‎09-14-2021

Thanks @amitchandak , fixed!

John

Conditional formatting

Helpful resources

Join us at the Microsoft Fabric Community Conference

Microsoft Fabric Community Conference 2025

A Year in Review - December 2024

How to Get Your Question Answered Quickly

Join us at the 2025 Microsoft Fabric Community Conference