Forum Discussion
How to filter by an interaction matrix
Hi all, I have a few data sources that have what I'm calling 'interaction matrices'. This is where they have a number of stakeholders and a number of events, causes or similar where they record a...
suparnababu8
Super User
Super UserHi CGReynolds
If I understand correct you want to slicer by client. Please follow below steps.
1) Load your table in Power Query editor.
2) Navigate to transform--> choose the columns for your clients (Client 1, Client 2, Client 3) and select Unpivot only selected Columns.
Now close and apply power query editor.
3) Now in Power BI desktop, take a matric chart and drag the fileds Rows - Event, Columns - Cient, Values - Value
4) add a slicer to your canvas and drag Client column in to slicer then select, Dropdown under Slicer setting options.
5) now you can slice and dice whichever field you want from Client slicer.
Attaching pbix for your reference.
Let me know if it works
Thanks!