Dynamic title

[Apple08]

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:

Titel = "Report - "& SELECTEDVALUE(Dates[Week Ending Friday]) & UNICHAR(10) & "update at "& Selectedvalue('Code[report_code]) & UNICHAR (10)

Many thanks.

[Anonymous]

Hi @Apple08 ,

I found that you have solved the issue in this post:

Can you mark the useful reply to make this thread closed? More people will benefit.😀

Best Regards,

Stephen Tao

[Anonymous]

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.

[YukiK]

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.

[Apple08]

Thank you, I will re-post it on the Desktop section.