Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
You just need to select Unpivot Columns in Query Editor first.
https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415
You just need to select Unpivot Columns in Query Editor first.
https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415
Thank You
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |