topic Re: Title split by UNICHAR(10) doesn't work as expected in DAX Commands and Tips

Title split by UNICHAR(10) doesn't work as expected

bergen288 — Fri, 13 Jan 2023 18:17:24 GMT

I have the following DAX measure as the title of my line chart visaul. UNICHAR(10) is used to split title. However, it is splitted after "Dashed" instead. What's the problem and how to address it?

Thanks.

Number of Payments by Hour Title =

VAR __Today = FORMAT(MAX(PBI_XZ_Fraud_Alerts_Today_Check[to_day]), "Long Date")

RETURN

"Number of Payments by Hour on " & __Today & UNICHAR(10) & "Dashed Thin Line is Unassigned Payment"

Re: Title split by UNICHAR(10) doesn't work as expected

OwenAuger — Sun, 15 Jan 2023 00:00:47 GMT

Hi bergen288

This worked for me with a similar title measure:

Turn off "Text wrap" under Format pane > General > Title.

Then the title should display the "line feed" UNICHAR(10) characters correctly.

Regards,

Owen

Re: Title split by UNICHAR(10) doesn't work as expected

Anonymous — Mon, 16 Jan 2023 06:35:40 GMT

Hi bergen288

You need to close the "Text wrap" in Title

because if it is open, the title will be affected by the size of your visual, when you closed it, the measure you created can work:

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Title split by UNICHAR(10) doesn't work as expected

bergen288 — Tue, 17 Jan 2023 14:11:31 GMT

I accepted both of your answers as solutions.

Thanks.