I´m trying to create a new slicer for a series of dummy variables. My data is something like this:
My idea is to have one slicer that allow users to select the equipments that they want, then the dashboard should show all projects that have "1" in the equipments selected. Is it possible to do so or do I need to create one slicer for each Equipment and indicate to select "1" option in each slicer?
You can't really do what you want with the data structured the way it is. I would suggest using an unpivot operation in your query to convert the equipment columns into rows, then filter to only include the rows with 1's.
So the end result would be:
Project 1 Equipment 2 1
Project 1 Equipment 3 1
Project 2 Equipment 1 1
Project 2 Equipment 2 1
Then you can have a single slicer on the Equipment column.