Highlighting max & min value in column chart for date/date

DAX DAX Calculations
2

Hello @nikahafiz,

Thank You for posting your query onto the Forum.

Do you want to highlight the max and min day for each year? Like this -

image
image853×157 8.97 KB

In that case, below is the measure alongwith the screenshot of the final results provided for the reference -

Del-DpAr-Dur-MxMn-D-CF - Harsh =
VAR _Max_Value =
CALCULATE(
    MAXX(
        ALLSELECTED( 'Calendar' ) ,
            [Del-DpAr-Dur] ) ,
    ALLEXCEPT( 'Calendar' , 'Calendar'[Year] ) ,
    VALUES( 'Calendar'[Year] ) )

VAR _Min_Value =
CALCULATE(
    MINX(
        ALLSELECTED ( 'Calendar' ) ,
            [Del-DpAr-Dur] ),
    ALLEXCEPT( 'Calendar' , 'Calendar'[Year] ) ,
    VALUES( 'Calendar'[Year] ) )

VAR _Color =
IF( [Del-DpAr-Dur] = _Max_Value , "#F9D987" ,
IF( [Del-DpAr-Dur] = _Min_Value , "#AADBD6" ,
    "#D3D9B4") )
   
RETURN
_Color

Max Value For The Year 2015
Max Value For The Year 20151938×386 35.2 KB

Max Value For The Year 2016
Max Value For The Year 20161938×389 34.2 KB

The same will be applicable for the Min Values as well.

I’m also attaching the working of the PBIX file for the reference purposes.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh

demo-dataset2-JFK - Harsh.pbix (13.4 MB)

3 Likes