Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @eliasayy
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 @eliasayy
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?
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |