How to create a measure to change color for multiple measures

[Anonymous]

Hello!

I need to create a measure that will dynamically change bar/line chart colors for multiple measures.

Below is what i created and it's only working for first meausre i am referring (2022 ratio). 

Please help..!!

Color =

SWITCH(

TRUE(),

[Baseline 2020] > [2022 Ratio], "#ff0021",

[Baseline 2020] <= [2022 Ratio], "#229954",

[Baseline 2020] > [2021 Ratio], "#ff0021",

[Baseline 2020] <= [2021 Ratio], "#229954",

"#f70a02"

)

[v-xiaotang]

Hi @Anonymous 

Do you mean the red part is working but the blue part is not working? If so, we need some sample data and the measure [2021 Ratio], could you please provide them? Thanks.

Best Regards,

Community Support Team _Tang

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

[parry2k]

@Anonymous the condition itself is not going to dictate the solution, you need to provide sample data and your measure to understand the calculation. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hi @parry2k,

Please see below. 2021 Ratio is calcuated same logic as 2022 and baseline is a static #. 

[Baseline] = 0.1235

[2022 Ratio] = ([2022 # of Purchase Products])/([2022 # of Total Products])

[2022 # of Purchase Products] = CALCULATE(COUNT('Product'[Product # Purhcased],Filter(Date,Date[Year]=2022))

[2022 # of Total Products] = CALCULATE(COUNT('Product'[Product #],Filter(Date,Date[Year]=2022))

Thank you