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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |