Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Exlonghorn
New Member

Can active Filter info be embedded in a visual?

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.

 

Exlonghorn_0-1699632161738.png

 

1 ACCEPTED 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!

https://www.youtube.com/watch?v=kccmckYOmbw 

View solution in original post

3 REPLIES 3
arvindsingh802
Super User
Super User

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 


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

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.  

Exlonghorn_0-1699649804301.png

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!

https://www.youtube.com/watch?v=kccmckYOmbw 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors