Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Thanks in advance.
Solved! Go to Solution.
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:-)
Thank you @Anonymous and @PaulDBrown ,
Finally i am able to get this done.
Ans for Requirement 1:-
Ans for Requirement 2:-
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:-)
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?
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:-)
Thank you @Anonymous and @PaulDBrown ,
Finally i am able to get this done.
Ans for Requirement 1:-
Ans for Requirement 2:-
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.
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |