Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I want to put up and down arrows on a set of data.
I start simple
Arrow =
SWITCH(TRUE,
[This Week] > 0, "Up",
[This Week] < 0, "Down",
"Side"
)
and I get the result I expect.
Then I try
Arrow =
SWITCH(TRUE,
[This FY] > 0, UNICHAR(11165),
[This FY] < 0, "Down",
"Side"
)
and I get the result I expect
Then I add the other unichars
Arrow =
SWITCH(TRUE,
[This FY] > 0, UNICHAR(11165),
[This FY] < 0, UNICHAR(11167),
UNICHAR(11166)
)
and I don't get what I expect to see
I also tried the below but got the same result
Arrow =
VAR Up = UNICHAR(11165)
VAR Down = UNICHAR(11167)
VAR Side = UNICHAR(11166)
RETURN
SWITCH(TRUE(),
[This FY] > 0, Up,
[This FY] < 0, Down,
Side
)
What am I doing wrong? I've read through a fair few threads on Unichar issues and can't see where I'm going wrong.
Solved! Go to Solution.
If it still annoys you, try using the set of arrow icons from Conditional Formatting > Icons
Proud to be a Super User!
If it still annoys you, try using the set of arrow icons from Conditional Formatting > Icons
Proud to be a Super User!
thanks @ray_aramburo - did it with conditional formatting as you suggested in the end.
This seems to be a bug in Power BI. You can see in the attached pbix file that every value is returning the up arrow whereas it works correctly on dax.do - https://dax.do/lEEKvPALKstpSY/
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |