Interpret a conditional formatting

Question

HiHow you would interpret this conditional formatting rule which highlight the highest number?&nbsp; How you would write one which will highlight the lowest number. Any help would be very much appreciated. Thank you very much.&nbsp;

vojtechsima · Accepted Answer

Hi,&nbsp;lastnn30&nbsp;Create a measure to evaluate it:
LowestCountHighlight = 
var ValuesDisplay = 
    CALCULATETABLE(
        ADDCOLUMNS(
            SUMMARIZE(SafetyData, SafetyData[Injury Location],SafetyData[Incident Type]),
        "CountOfIncidentTYpe", CALCULATE(COUNTROWS(SafetyData), ALLEXCEPT(SafetyData, SafetyData[Injury Location]))),
    ALLSELECTED()
    )

var MinCOunt = CALCULATE(MINX(ValuesDisplay, [CountOfIncidentTYpe]))
var MaxCount = CALCULATE(MAXX(ValuesDisplay, [CountOfIncidentTYpe]))

var CurrentValue = COUNTROWS(SafetyData)

var Result = 
    SWITCH(TRUE(),
       CurrentValue = MinCOunt, "#F00",
       CurrentValue = MaxCount, "#0F0"
    )

return Result
Then use - Field Value in the Conditional formatting:

Or if you wanna have more control, you can return 1 and 2 (1 = min, 2 = max) and then in Conditional formatting -&gt; Rules, you can setup the colors accordingly (if value = 2 then some color etc.)

Forum Discussion

Interpret a conditional formatting

2 Replies

Related content

Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting