topic Measure To Conditional Format Max and Min value in Column Chart in DAX Commands and Tips

Measure To Conditional Format Max and Min value in Column Chart

Anonymous — Mon, 10 Oct 2022 11:25:48 GMT

hello everyone,
https://1drv.ms/u/s!Ag9tIyk2ofNRjks_kZruHDia1fok?e=4HcsBy
i have pbix file here with the below pic

my goal is to conditional format the column bars of which value is the minimum to be red and the maximum to be green
i appreciate your help

Re: Measure To Conditional Format Max and Min value in Column Chart

VahidDM — Mon, 10 Oct 2022 11:51:10 GMT

Hi Anonymous

Please download the attached file.

Bar Chart Color = VAR _Max = CALCULATE ( MAXX ( ADDCOLUMNS ( VALUES ( 'Calendar'[Month] ), "AA", [Total Revenue] ), [AA] ), REMOVEFILTERS ( 'Calendar'[Month] ) ) VAR _Min = CALCULATE ( MINX ( ADDCOLUMNS ( VALUES ( 'Calendar'[Month] ), "AA", [Total Revenue] ), [AA] ), REMOVEFILTERS ( 'Calendar'[Month] ) ) RETURN SWITCH ( [Total Revenue], _Max, "Green", _Min, "Red" )

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

LinkedIn | Twitter | Blog | YouTube

Re: Measure To Conditional Format Max and Min value in Column Chart

Anonymous — Mon, 10 Oct 2022 13:32:26 GMT

Thank you very much will this work with calendar date heirarchy too? Or just the month?