Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Dynamic Titles in multiple lines

Hello All,

 

I have written a measure for creation of dynamic title as below.

 

Title by month For Plan Contri = IF(
ISCROSSFILTERED('Month Year'[LastMonth]),
"Plan Contribution "& FIRSTNONBLANK('Month Year'[Month Year], TRUE) &" ","Plan Contribution")

When i use it in card it shows as below image

1.PNG

 

 

 

Well i would like to show the month-year in new line, i.e below the Plan Contribution.

 

                                                   Plan Contribution

                                                         Apr-17

 

 

Any help.

Mohan V

 

1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

Hi @Anonymous,

 

Currently, there seems no possible way to display a carriage return in a Card visual.

 

However, as a workaround, you could turn on the "word wrap" function under the Card format tab. Then, decrease the width of card visual. The month-year part will be displayed on next line automatically.

1.PNG

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

You can try using a Unicharacter.

If you put off Word Wrap and you conditional format your title with the following measure it will work:

 

Title by month For Plan Contri = IF(
ISCROSSFILTERED('Month Year'[LastMonth]),
"Plan Contribution " & UNICHAR(10) & FIRSTNONBLANK('Month Year'[Month Year], TRUE) &" ","Plan Contribution")

The UNICHAR(10) stands for an "Enter" .

Let me know if this worked for you?!

v-yulgu-msft
Employee
Employee

Hi @Anonymous,

 

Currently, there seems no possible way to display a carriage return in a Card visual.

 

However, as a workaround, you could turn on the "word wrap" function under the Card format tab. Then, decrease the width of card visual. The month-year part will be displayed on next line automatically.

1.PNG

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.