Forum Discussion
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
- amitchandakSuper User
PBIDevNoob , at few, placed it might not work. Have given enough height for it to work.
- PBIDevNoobHelper I
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.