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 all
I would like to have a dynamic title for a table, the title includes the dates and a code when users select from slicer. I got the formula below to add in the week ending Friday date and it works (however I don't quite understand the UNICHAR (10) and I just copied it from Google and it seems works). Now I need to add in the code and I have issue as the code is a combination of number and character, e.g. 2122AB
Please could anyone help me how to edit the formula below:
Hi @Apple08 ,
About UNICHAR(), it returns the Unicode character referenced by the numeric value. Refer to UNICHAR function (DAX) - DAX | Microsoft Docs.
About dynamic titles with multi filters or slicers, refer to Dynamic titles with multiple slicers or filters in Power BI - YouTube.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think you'd get more answers if you post this on Desktop section of this community than Power Query since your question is pretty much around DAX.
I myself am not familiar with UNICHAR() but I've only successfully used in a calculated column, so maybe modifying your measure to a calc column might help.
Thank you, I will re-post it on the Desktop section.
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.