cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
balakrishna141 Regular Visitor
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".Sample Image.PNG

 

 

 

 

 

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?

 

Thanks in advance.

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
husnabanu Regular Visitor
Regular Visitor

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

Hi @balakrishna141 ,

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

balakrishna141 Regular Visitor
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
husnabanu Regular Visitor
Regular Visitor

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

Hi @balakrishna141 ,

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

balakrishna141 Regular Visitor
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

husnabanu Regular Visitor
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?

PaulDBrown Senior Member
Senior Member

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

@balakrishna141 

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.

husnabanu Regular Visitor
Regular Visitor

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

image.png

 

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

balakrishna141 Regular Visitor
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)")