Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is it possible to embed the active filter info into a visual (as in the highlight in the capture)? This would help with dashboard creation and use, especially if the same visual is put into a dashboard multiple times with different filter criteria applied to each. I know this can be done when copying and pasting a visual out of the service, but I want to have the same info visible within a visual that is in a dashboard.
Solved! Go to Solution.
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!
Yes, 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!