Forum Discussion

PBIDevNoob's avatar
PBIDevNoob
Helper I
6 years ago

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