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

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.

Reply
PBIDevNoob
Helper I
Helper I

New Line in Action Tooltip

Hi! 

 

I want to create a summary of filters applied to my report. 

I added an "Information" button and gave it a bookmark action "None" so I can add a measure as tooltip. 

 

For some reason the tooltip doesn't have the line break/new like that's on my dax. I've tried using a manual line break and and all combinations of UNICHAR(10) and UNICHAR(13), but it's not working. I've also tried this with no luck: https://community.powerbi.com/t5/Desktop/Have-new-line-character-in-Tooltip/td-p/348130

 

But i've also I tried using the filter dump generated from Dax Studio:

 

DumpFilters = 
VAR MaxFilters = 3
RETURN
IF ( 
    ISFILTERED ( Table[Filter1] ), 
    VAR ___f = FILTERS ( Table[Filter1] ) 
    VAR ___r = COUNTROWS ( ___f ) 
    VAR ___t = TOPN ( MaxFilters, ___f, Table[Filter1] )
    VAR ___d = CONCATENATEX ( ___t, Table[Filter1], ", " )
    VAR ___x = "Table[Filter1] = " & ___d & IF(___r > MaxFilters, ", ... [" & ___r & " items selected]") & " " 
    RETURN ___x & UNICHAR(13) & UNICHAR(10)
)
 & IF ( 
    ISFILTERED ( Table[Filter2] ), 
    VAR ___f = FILTERS ( Table[Filter2] ) 
    VAR ___r = COUNTROWS ( ___f ) 
    VAR ___t = TOPN ( MaxFilters, ___f, Table[Filter2] )
    VAR ___d = CONCATENATEX ( ___t, Table[Filter2], ", " )
    VAR ___x = "Table[Filter2] = " & ___d & IF(___r > MaxFilters, ", ... [" & ___r & " items selected]") & " " 
    RETURN ___x & UNICHAR(13) & UNICHAR(10)
)

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@PBIDevNoob , at few, placed it might not work. Have given enough height for it to work.

 

Also refer :https://www.fourmoo.com/2019/07/09/dax-how-to-get-a-line-break-in-a-dax-measure-for-labels-or-titles...

That's too bad. It works when the tooltip is in a chart, just not when it's an action tooltip, which I would have supposed should have the same functionality. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.