Conditional formatting with Icons

[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 downward arrow color from Red to Green.

thanks,

[Anonymous · Accepted solution]

Hi @ayush_mriti ,

You can make the following adjustment to get it, please find the details in the attachment.

1. Update the formula of measure [fmm] as below

Conditional formatting =
SWITCH (
    TRUE (),
    [Current] > [Prior], 1,
    [Current] < [Prior], 2,
    [Current] = [Prior], 3
)

2. Change the conditional formatting configuration

Best Regards

[ayush_mriti]

Both the solution worked. Thanks a lot!

[Jai-Rathinavel · Accepted solution]

Hi @ayush_mriti , Replace your dax with the below one.

fmm = SWITCH(
             TRUE(),
             [Current] > [Prior],"ColoredArrowUp",
             [Current] > [Prior],"ColoredArrowDownGreen",
             [Current] = [Prior],"TriangleMedium")

Did I answer your question ? Please mark this post as a solution.

Thanks,

Jai 

[Anonymous · Accepted solution]

Hi @ayush_mriti ,

You can make the following adjustment to get it, please find the details in the attachment.

1. Update the formula of measure [fmm] as below

Conditional formatting =
SWITCH (
    TRUE (),
    [Current] > [Prior], 1,
    [Current] < [Prior], 2,
    [Current] = [Prior], 3
)

2. Change the conditional formatting configuration

Best Regards