Forum Discussion
ayush_mriti
1 year agoHelper I
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...
- Anonymous1 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
- 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
ayush_mriti
1 year agoHelper I
Both the solution worked. Thanks a lot!