How to highlight min and Max in column chart for small multiple and how to solve it

[shafiz]

I want to highlight min and max total value in column chart where x axis represent year as well as label (Column in my dataset) used as small multiples. For simple column chart I can acheive it easily but for small multiple I am unable to solve this.

Here is my formula for min and max :

MinMax =

VAR Vals =

    CALCULATETABLE(

        ADDCOLUMNS (

            SUMMARIZE ( Dummy, Dummy[Year],Dummy[Label]),

            "@SalesAmt", [Total]

        ),

        ALLSELECTED ()

    )

VAR MinValue = MINX ( Vals, [@SalesAmt] )

VAR MaxValue = MAXX ( Vals, [@SalesAmt] )

VAR CurrentValue = [Total]

VAR Result =

    SWITCH (

        TRUE,

        CurrentValue = MinValue, 1,

        CurrentValue = MaxValue, 2,

        0

    )

RETURN

IF(ISINSCOPE(Dummy[Label]),

    Result,

    0

)

I want to highlight min and max for every label. Is it possible? If possible, kindly guide me towards the solution.

Here is my dummy data :

LabelYearValue

A	2011	13
A	2011	25
A	2010	34
A	2015	33
A	2015	23
A	2015	11
A	2016	55
A	2017	67
A	2017	45
B	2011	130
B	2011	35
B	2010	36
B	2015	67
B	2015	89
B	2015	90
B	2016	55
B	2017	67
B	2017	45
C	2011	100
C	2011	70
C	2010	57
C	2015	67
C	2015	89
C	2015	90
C	2016	55
C	2017	67
C	2017	45
D	2011	130
D	2011	35
D	2010	36
D	2015	67
D	2015	89
D	2015	90
D	2016	55
D	2017	67
D	2017	200

Here is the image. I want to highlight min and max in each quadrant.

[jdbuchanan71 · Accepted solution]

@shafiz 

I think this is what you are looking for.  Assuming [Total] is a measure that SUMS your Value column.

Year Format = 
VAR _YearMin = MINX ( ALLSELECTED ( 'Table'[Year] ), [Total] )
VAR _YearMax = MAXX ( ALLSELECTED ( 'Table'[Year] ), [Total] )
RETURN
SWITCH ( 
    TRUE(),
    [Total] = _YearMin, "Grey",
    [Total] = _YearMax, "Red"
)

Make sure this measure data type is Text.

Then this measure get applies and the Columns > Colors conditional format.

Which gives us this.

[shafiz]

Thanks @jdbuchanan71 for showing me the right path to acheive this. Exactly this is what I want. 👍