Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi There
I've created a measure which shows an up arrow if the current month is greater than the previous month however I would like to add a down arrow if it is lower than the previous month and if there is no data or the values are the same just a line (I have the Unichar codes available to hand)
Here is my code so far
Difference =
SWITCH(TRUE(),[%Extreme]<'Sample Data'[%Extreme LM],
UNICHAR(9660), BLANK())
Any help would be greatly appreciated
Thanks
Dan
Solved! Go to Solution.
Hi @Daniel_B ,
if you replace the unichar codes by the colours you want then use that measure as your condittional formatting should work on the color of the arrows as needed.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsOkay so I've solved this challenge now but I would like to know if I've used the below measure for a scorecard to get the trend arrow, is there a way of making it change color depending on the UNICHAR code I'm using for the arrow based on the results (see code below) - as I'm using a scorecard I know I can't use conditional formatting on the value
%Difference Arrow = IF([%Extreme]>[%Extreme LM],UNICHAR(9650),IF([%Extreme]<[%Extreme LM],UNICHAR(9660),UNICHAR(9644)))
Arrow up = RED
Arrow down = GREEN
Line = Yellow
Hi @Daniel_B ,
if you replace the unichar codes by the colours you want then use that measure as your condittional formatting should work on the color of the arrows as needed.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Daniel_B ,
You need to use a similar measure to this one:
Difference =
SWITCH (
TRUE (),
[%Extreme] < 'Sample Data'[%Extreme LM]
|| [Measure] = BLANK (), UNICHAR ( 9660 ),
[%Extreme] = 'Sample Data'[%Extreme LM], UNICHAR ( 9999 ),
BLANK ()
)
Replace the codes for unichar and the measure for the ones that adjust to your model.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |