Dynamic filter on column based on column names from slicer

[dp106]

Hi,

I am new to Power BI, so not sure if this is even possible.
 
We are receiving customer data that has a flattened structure (approx 50 columns have boolean values, these are questions that were answered when the customer was onboarded into the system).
 
One of the requirement in the report is to provide selection of all the 50 columns (questions) as filter (slicer) and based on the selection, the results should filter the data.
 
Here is structure of the table
 
Customer Name   Customer Type Risk Rating Question1 Question2 Question3 Question4 Question50.
 
 
Question Slicer
Question1
Question2
Question3
Question4
Question50
 
if the user selects question 1 then it should select all records where question1 (column name) = 'Y'
 
Thanks

[v-chuncz-msft · Accepted solution]

@dp106,

You just need to select Unpivot Columns in Query Editor first.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415

[dp106]

Thank You