I am using two sharepoint lists: One list with Customer names and a second list as a large set of requirements where we enter the customer values for each of these. On a dashboard, I would like to have a matrix where I can select one or more of the requirements and see which customers have a value set for that requirement. I would like any suggestions on how this can be done.
This can be achieved by importing a pivot table of Customers and Requirements into Power BI and then unpivoting the requirements. The matrix report can filter by any of the requirements. I can't use this method because I am trying to use the native data entry forms from Sharepoint Lists but these forms don't handle pivot table data well.
I would suggest importing the data into a PBIX, which will then allow you to shape the data as you require and possibly create more tables which you can then use to filter in your data model.
The @GilbertQ's suggestion could be the best way to do that. Whatever the formats of the original data they are, they are all queries in table format in Power BI. You can manipulate them in Power BI after loading into Power BI.
Could you please mark the proper answers as solutions?