cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
v-rosatt New Member
New Member

Is there a way to filter a metrix report by Value Names similar to what can be done with a pivot

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.

 

 

3 REPLIES 3
Super User
Super User

Re: Is there a way to filter a metrix report by Value Names similar to what can be done with a pivot

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.


Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
Community Support Team
Community Support Team

Re: Is there a way to filter a metrix report by Value Names similar to what can be done with a pivot

Hi @v-rosatt,

 

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. 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Is there a way to filter a metrix report by Value Names similar to what can be done with a pivot

Hi @v-rosatt,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.