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 minimum to be red and the maximum to be green
i appreciate your help
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!!
2 Replies
- VahidDM
Super User
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!!