Forum Discussion
Measure To Conditional Format Max and Min value in Column Chart
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 m...
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!!
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!!
Thank you very much will this work with calendar date heirarchy too? Or just the month?