custom conditional formatting?

[Anonymous]

Hey guys, basically I have these three columns and I need to make conditional formatting so as that if first column value exceeds second column value, then return the difference. Otherwise, if it does not exceed the value, return 0:00:00 In a time value. Any ideas how to do that? 
Many thanks

[FrankAT · Accepted solution]

Hi @Anonymous 

what about the following solution:

Difference = 
VAR _Calculation = CALCULATE(
                            MIN('Table'[naujasbandymas]) - MIN('Table'[norma]), 
                            FILTER('Table', 'Table'[naujasbandymas] >= 'Table'[norma])
                    )
RETURN
    IF(_Calculation = BLANK(),TIME(0,0,0), _Calculation)

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous]

@FrankAT You might be able to help me now. 

This is my table. First column is time in the whole number format and then second one is norm that should not be exceeded, if it exceeds this norm, then return the difference(Third column) between the two, but if it does not exceed 04:30 then return the actual time. 

[Anonymous]

@FrankAT 

That would actually be my ideal solution, however i get the following error : 

[FrankAT]

Hi @Anonymous 

the MIN() function doesn't accept a measure as an argument. If [naujasbandymas] is a measure my formula fails.

How does your measures and tables look like?

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous]

Yes, i managed to change it from the measure to actual variable and it works perfectly now, many many thanks. 

[amitchandak]

@Anonymous , you can create a color measure and use that in conditional formatting using "Field Value" Option

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values