Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |