Forum Discussion
custom conditional formatting?
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
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)
6 Replies
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-valuesHi 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)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)
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.
