Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello:
I have created a table visual. The underlying Excel table contains check marks, which were not retained when I imported the table. Now that I've imported the table, I'm trying to change the existing text in several columns (specifically, a "Y") to a check mark.
Based on preliminary research, I may be able to use the UNICHAR function to replace the "Y" with a check mark, but haven't gotten it to work. Would appreciate any guidance.
Thank you!
Solved! Go to Solution.
@johnwedeles - Yes, you could use a nested IF statement or use a SWITCH(TRUE()...) statement.
Hello @Greg_Deckler - is it possible to add an additional (or nested) filter to this formula? For example, I want to say:
If column 1 contains "Y", then UNICHAR 10003
and (this would be the additional filter)
if column 1 contains "-", then UNICHAR 8211
Thank you!
@johnwedeles - Yes, you could use a nested IF statement or use a SWITCH(TRUE()...) statement.
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |