cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Niiru1
Helper V
Helper V

Switch colour card filter by field value

I'm formating a card by FIELD VALUE

 

Is there a way to get this switch formula to turn greater than 0 green e.g. "#094" and red if less than 0 e.g. "#d64550";

 

My current code is:

Measure Value Color = SWITCH(TRUE(),
[% Average 2019] >0,"#D64550",
[%Average 2019] =0,"#252423",
[% Average 2019] <0,"#094",
[% Average 2020] >0,"#D64550",
[% Average 2020] =0,"#252423",
[% Average 2020] <0,"#094"
)
 
It keeps turning red for some reason when it's +18.54%
Attendance average.PNG
Thanks
2 REPLIES 2
daxer-almighty
Solution Sage
Solution Sage

You can't have one measure that will return different values for the average in 2019 and 2020. Only the first true condition will be honored. So, you see 18.54% being red because this color comes from the other measure. In all honesty, in your color measure none of the 3 last conditions will ever be hit since the first 3 already cover all possibilities. Use 2 different color measures for the 2 different numerical measures. By the way, in the measures given by @nandukrishnavs you don't have to multiply by 100 since you're only comparing to 0.

nandukrishnavs
Community Champion
Community Champion

@Niiru1 

 

Try to write two measures.

 

Color2019 =
VAR _val = [% Average 2019]*100
VAR _result =
    SWITCH (
        TRUE (),
        _val > 0, "#D64550",
        _val = 0, "#252423",
        _val < 0, "#094"
    )
RETURN
    _result
Color2020 =
VAR _val = [% Average 2020] * 100
VAR _result =
    SWITCH (
        TRUE (),
        _val > 0, "#D64550",
        _val = 0, "#252423",
        _val < 0, "#094"
    )
RETURN
    _result

 

If your format of measure ([% Average 2020], [% Average 2019) is not the percentage, then you don't need to multiply 100.

 




Regards,
Nandu Krishna

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍

Proud to be a Super User!


Regards,
Nandu Krishna

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors