Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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

View solution in original post

Anonymous
Not applicable

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

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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
Not applicable

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?

Anonymous
Not applicable

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

Anonymous
Not applicable

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
Not applicable

Hi @Anonymous ,

 

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

 

And is there any suggestion/solution for Requirement-2

@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.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.