Forum Discussion
Can active Filter info be embedded in a visual?
And the other problem is that you have to specify every filter individually, which can be a real problem if there are dozens of filters. This solves that problem using DAX Studio. Take the results they put into a tooltip, and instead put that measure into the subtitle. Voila!
Community ChampionYes, you can use below
Filters Selected =
IF (
ISFILTERED ( MyTable[MyColumn] ),
CONCATENATEX ( FILTERS ( MyTable[MyColumn] ), MyTable[MyColumn], ", " ),
"ALL"
)
For detailed tutorial refer https://www.datapears.com/post/creative-ways-to-show-filter-selections-on-your-power-bi-reports
Unfortunately, that appears to try to solve the problem by creating a second visual dedicated only to showing the filter info. However, you led me to a solution that keeps the filter info in the main visual. Using your DAX, the measure can be added within a visual via the subtitle function in the Visualizations Pane>Format>General>Subtitle option.
And the other problem is that you have to specify every filter individually, which can be a real problem if there are dozens of filters. This solves that problem using DAX Studio. Take the results they put into a tooltip, and instead put that measure into the subtitle. Voila!