conditional formatting with Icons to show different colors

[ayush_mriti]

Hi All,

I am creating a report containing conditional formatting with Icons. 

In the screenshot, I am comparing prior Vs current. If the current is less than prior then M/M trend would show Green down arrow,  instead of Red arrow. In the calculation I used predefined icons name and convert then to Icon (screenshot attached). Can someone help me to change the arrows to different colors beside Red, Green or Grey. Or just have white color with a black boarder of arrow symbol.

thanks.

[Anonymous]

Hi @ayush_mriti ,

Is this issue solved now? If you have any questions, please feel free to share with us.

And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. 🙂

Thanks for your understanding!

Best regards,

Lucy Chen

[Uzi2019]

Hi @ayush_mriti 

For conditional  and border color formatting try this video this might help you

https://www.youtube.com/watch?v=XYJJgwDVVAQ

https://www.youtube.com/shorts/AXyVldDPgKU

https://www.youtube.com/watch?v=o2jSUHU722w

https://www.youtube.com/watch?v=Moxktpv4z7E

I hope above videos would help you to create conditional on arrow formatting!

[Bibiano_Geraldo · Accepted solution]

Hi @ayush_mriti ,

Update your measure for something like this:

Trend Value = 
SWITCH(
    TRUE(),
    [Current] < [Prior], -1,   -- Return -1 if Current is less than Prior
    [Current] > [Prior], 1,    -- Return 1 if Current is greater than Prior
    [Current] = [Prior], 0     -- Return 0 if Current equals Prior
)

Now select your desired measure in field pane to format, and choose Icons as conditional formatting:

Format style: Rules
Field based on: Trend value.
Icon layout: choose your prefered

Alignement: choose your prefered

Style: As shown bellow

Now let set the rules as bellow:

Now click on dropdown icon and choose the desired icon as shown bellow:

My rules look like this:

Now click on ok, and your will achieve your goal.