\<< [[§§ Power BI tips and tricks]] --- # TL;DR Showing all filters selected is a requirement very common by business stakeholders. Although Power BI offers some options, they are not as intuitive as simply having a card displaying the information. Such card can be built using DAX combining functions like ISFILTERED() plus VALUES() and CONCATENAX() to get a string output containing all filter values from given slicers. --- Example measure built using that logic: ``` Filter Combined = VAR Cities = IF( ISFILTERED('Data Table'[City]), "Cities selected: " & CONCATENATEX(VALUES('Data Table'[City]), 'Data Table'[City], ", "), "All Cities" ) VAR Categories = IF( ISFILTERED('Data Table'[Category]), "Categories selected: " & CONCATENATEX(VALUES('Data Table'[Category]), 'Data Table'[Category], ", "), "All Categories" ) VAR Months = IF( ISFILTERED('Date'[Month]), "Month selected: " & CONCATENATEX(VALUES('Date'[Month Name Short]), 'Date'[Month Name Short], ", "), "All Month" ) RETURN Cities & UNICHAR(10) & Categories & UNICHAR(10) & Months ``` --- # References Original post: - https://www.linkedin.com/posts/valeriejunk_have-you-ever-been-asked-to-show-which-filters-activity-7307748981906833408-uOWi?utm_source=share&utm_medium=member_desktop&rcm=ACoAAAvIcMsBDr8s2jNyhqq-QLRVmwe5z68gWPU - https://www.valeriejunk.nl/show-all-applied-filters-in-power-bi/