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.
Good evening,
Can someone point me in the right direction? I'm trying to include an exclamation mark using the UNICHAR function but I'm obviously doing something wrong:
Is there a library somewhere with the correct UNICODEs? the one I'm using is rendering the wrong symbol.
Thanks,
Paul.
Proud to be a Super User!
Paul on Linkedin.
Solved! Go to Solution.
UNICHAR expects decimal codes. Your information contains hexadecimal codes.
Hex 2757 = Decimal 10071.
You can find a conversion function in the link below this video (the link starts at the point where the function is explained).
This is how the function can be used to convert "2757" from hexadecimal to decimal:
= fnNumberBaseConversion("2757", 16, null)
Thank you Marcel for the explanation and video!
EDIT: I've been looking around and found an online conversion tool if anyone is interested:
https://www.binaryhexconverter.com/hex-to-decimal-converter
Proud to be a Super User!
Paul on Linkedin.
UNICHAR expects decimal codes. Your information contains hexadecimal codes.
Hex 2757 = Decimal 10071.
You can find a conversion function in the link below this video (the link starts at the point where the function is explained).
This is how the function can be used to convert "2757" from hexadecimal to decimal:
= fnNumberBaseConversion("2757", 16, null)
Thank you Marcel for the explanation and video!
EDIT: I've been looking around and found an online conversion tool if anyone is interested:
https://www.binaryhexconverter.com/hex-to-decimal-converter
Proud to be a Super User!
Paul on Linkedin.
By the way, you may help accept the solution above. Your contribution is highly appreciated.