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.
I try to display 2 different symbols in a table depending on a status - here is the small dax function:
test status = SWITCH(TRUE(); [Projectstatus] = 0; UNICHAR(9940); [Projectstatus] = 1; UNICHAR(9989); "")
Code works for different unichar-values - it seems to be a problem with the number range that i'm in. It ends in the result that the unichar(9989) is displayed for all rows:
Selecting only the status "0" the result is correct:
Selecting other values the result ist correct:
Any tipps / hints / thoughts on this subject or problem. Is it a bug in the unichar / switch function? Thx in advance for your help.
Best regards,
Stephan
Solved! Go to Solution.
Hello ! i do not have a final solution, whoever i found a work around to use the unichar symbols:
status char = SWITCH(TRUE(); AVERAGE(Testtabelle[Status]) = 1; UNICHAR(9989); AVERAGE(Testtabelle[Status]) = 0; UNICHAR(9940)&" "; "" )
Adding a character and the end from one of the selections works fine.
Best regards,
Stephan
Hello ! i do not have a final solution, whoever i found a work around to use the unichar symbols:
status char = SWITCH(TRUE(); AVERAGE(Testtabelle[Status]) = 1; UNICHAR(9989); AVERAGE(Testtabelle[Status]) = 0; UNICHAR(9940)&" "; "" )
Adding a character and the end from one of the selections works fine.
Best regards,
Stephan
Hi guys,
the code is correct, the problem is somewhere else. I tried to reproduce your problem and it also didn't work for me. What I tried was to take another value as parameter of UNICHAR and voila, it worked. It means there is a bug in Power BI.
Do you know how to report it?
status char = VAR UP = UNICHAR ( 9989 ) VAR DOWN = UNICHAR ( 940 ) VAR Result = SWITCH ( TestTable2[Status]; 0; DOWN; 1; UP; BLANK () ) RETURN Result
Hi Nolock,
i also believe that there is a bug in Power BI - i found also a work around (see my reply).
I don't know, how to report this as a bug to the power bi team - could you point me into the right direction - Thanks.
best regards,
Stephan
I've asked the uncle Google and there is a separated forum for that: https://community.powerbi.com/t5/Issues/idb-p/Issues
@sfuhr, do you take care about it?
@Nolock -> reported as a bug.
https://community.powerbi.com/t5/Issues/Bug-using-switch-function-with-unichar/idi-p/631819#M39493
Thx for your help... Stephan
Covering 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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |