Forum Discussion

ayush_mriti's avatar
ayush_mriti
Helper I
1 year ago
Solved

Conditional formatting with Icons

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 d...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

  • Jai-Rathinavel's avatar
    1 year ago

    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