Forum Discussion
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 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,
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
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
3 Replies
Both the solution worked. Thanks a lot!
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
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
