Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Trend Symbols in Table/Matrix visual in Power BI

Hi Team,   I have a requirement in table/Matrix visual formatting  and i am not very sure it is possible or not? Please suggest me if there is any possibility.  If we see below table , each count...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    you can make use of KPI ,

     

    QoQKPI =
    VAR Down =
        UNICHAR ( 11167 )
    VAR Up =
        UNICHAR ( 11165 )
    RETURN
        IF ( [QoQ Change1] < 0, Down, IF ( [QoQ Change1] > 0, Up ) )

     

    I hope this helps you:-)

  • Anonymous's avatar
    Anonymous
    7 years ago

    Thank you Anonymous and PaulDBrown ,

     

    Finally i am able to get this done.

    Ans for Requirement 1:-

     

    QKPI = VAR Down = UNICHAR(9660)
    VAR Up = UNICHAR(9650)
    VAR Nut = UNICHAR(9654)
    RETURN IF([Measure Name]=0,Nut,IF([Measure Name]<0,Down,Up))
     

    Ans for Requirement 2:-

    Measure = FORMAT([Measure Name],"(+#,##,#0);(-#,##,#0)")
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

you can make use of KPI ,

 

QoQKPI =
VAR Down =
    UNICHAR ( 11167 )
VAR Up =
    UNICHAR ( 11165 )
RETURN
    IF ( [QoQ Change1] < 0, Down, IF ( [QoQ Change1] > 0, Up ) )

 

I hope this helps you:-)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

Thank you very much for your response , i will try this methode.

 

And is there any suggestion/solution for Requirement-2

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Anonymous 

    Requirement 2:
    Measure =
    VAR sign = IF([QoQ Order Change] > 0; "+"; BLANK())
    Return
    [Current Quarter Orders] & " (" & sign & [QoQ Order Change] & ")"

     

    See if that is what you want.