cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Panos Frequent Visitor
Frequent Visitor

Text field to show the selected filters

How could I show what multiple filters are selected on a report page?

I have used 2 fields as filters. The first one is Data Subject and the second one is Request Types. My current formula only shows the selected filters from Request Types. How can I also get the filters selected from Data Subject in the same formula?

Filters Selected =
IF (
    ISFILTERED ( 'DSAR Log'[Request Types] ),
    CONCATENATEX ( FILTERS ( 'DSAR Log'[Request Types]  ), 'DSAR Log'[Request Types] , ", " ),
    "ALL"
)
filters.PNG
1 ACCEPTED SOLUTION

Accepted Solutions
OwenAuger Super Contributor
Super Contributor

Re: Text field to show the selected filters

This article is a pretty good guide, and shows how you can use DAX Studio to create the measure:
https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/

Essentially it amounts to repeating code similar to your existing code for every column, with some extra bells and whistles. You should be able to adapt this to your needs.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
OwenAuger Super Contributor
Super Contributor

Re: Text field to show the selected filters

This article is a pretty good guide, and shows how you can use DAX Studio to create the measure:
https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/

Essentially it amounts to repeating code similar to your existing code for every column, with some extra bells and whistles. You should be able to adapt this to your needs.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

Panos Frequent Visitor
Frequent Visitor

Re: Text field to show the selected filters

I got it done after reading the article. Thank you very much for your help!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 167 members 1,941 guests
Please welcome our newest community members: