cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## 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 country wise current and previous Quarter "Total Orders".

Requirement-1:-

If we see last Column "QoQ Change1" , there are Up and Down Symbol with colors. So actually if the difference between current quarter and Previous is negative then Down arrow with Red color.

Requirement-2:-

If we see the first column value  "Current Quarter Orders(Q2 FY19)" , 50 (+10) of Asutralia.

So 50 is the actual order of this quarter and +10 is the difference of previous quarter with positive number

So is this possible or any work around?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Regular Visitor

## Re: Trend Symbols in Table/Matrix visual in Power BI

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:-)

Regular Visitor

## Re: Trend Symbols in Table/Matrix visual in Power BI

Thank you @husnabanu 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)")
6 REPLIES 6
Regular Visitor

## Re: Trend Symbols in Table/Matrix visual in Power BI

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:-)

Regular Visitor

## Re: Trend Symbols in Table/Matrix visual in Power BI

Hi @husnabanu ,

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

And is there any suggestion/solution for Requirement-2

Regular Visitor

## Re: Trend Symbols in Table/Matrix visual in Power BI

yeah do try and let me know if is working for you the way you wanted and the second requirement you want those numbers to be splitted have i understood correct?

Senior Member

## Re: Trend Symbols in Table/Matrix visual in Power BI

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.

Regular Visitor

## Re: Trend Symbols in Table/Matrix visual in Power BI

This is what i created based on your requriment basically you can create KPIs by two ways one by passing unichar() codes and the other is by image URL

If this has helped you please mark as accepted so that it can help others too:-)

Regular Visitor

## Re: Trend Symbols in Table/Matrix visual in Power BI

Thank you @husnabanu 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)")