Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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)
)
@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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.