A slicer to select a series of fields that are filtered for value 'Y'

[jfarj]

Hi

I'm trying to create a slicer that filters fields (Y/N fields) where the field value is 'Y'. I'd also like it to filter mutually inclusively for multiple selections e.g. filtering for all records where Other charitable purposes is 'Y' OR The advancement of amateur sport is 'Y'.

I've tried creating a field parameter slicer like this: 

Then I used a second slicer (with the field parameter in the Values well) to filter for 'Y'.

I was wondering if there might be a way to do this without the second slicer - automatically selecting the 'Y' values of each field (and somehow getting it to filter mutually inclusively when multiple selections are made).

My .pbix file and source data are accessible via the following links (this is a public dataset).

NICharityMap_exp1anon1p1_v5.pbix

AllCharityDetails_8319_exp1anon1p1_v1.xlsx

Any help or guidance would be really appreciated.

Best Wishes
jfarj

[jfarj]

Hi johnt75

Thank you very much for your response. This is fantastic - more than I could've asked for!

I really appreciate your time creating the tables and model. The power query steps are very clear.

[johnt75 · Accepted solution]

You can do this by changing the data model. Instead of using a field parameter, create a new table which lists all the distinct purposes and then create a bridge table linking that to the main table. Use the separate purposes table for the slicer.

See the attached PBIX for the Power Query steps to create the Purpose and Bridge tables.