Forum Discussion

msbiuser1's avatar
msbiuser1
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Icon indicators as kpi

How to bring icon with down arrow in red and up arrow in green without using unicode charector. Just wanna know other ways of doing.

  • yes, it is possible. Create a table with measure like:

    m1= if([measure]>=0,1,0) and use in table. Hide the column header.

    Now right clik the measure droped in field and condition formating on icons. Apply your rules base on m1.

    Select your symbol and rules. Resize the table to match the kpi card feel.

    Good to implement!!!

2 Replies

  • yes, it is possible. Create a table with measure like:

    m1= if([measure]>=0,1,0) and use in table. Hide the column header.

    Now right clik the measure droped in field and condition formating on icons. Apply your rules base on m1.

    Select your symbol and rules. Resize the table to match the kpi card feel.

    Good to implement!!!

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User

    msbiuser1 ,

    Are you expect something in conditional formatting or need to write DAX code?

    Thanks,

    Arul