Forum Discussion
Power BI Matrix Visual to be Filtered by Multiple Slicers - Design Guidance
Ask the owner of the dataset to refactor their data model. You can also choose to connect to each table separately (or only the tables you need) and to rewire them in a more meaningful fashion.
@lbendlin - Thanks for your response.
So I have Quantity and Global Position in the Holdings table. For Slicers -
Asset Type and Primary Identifier - Comes from the Security table
Parent Issuer and Issue - Comes from Issuer table
Client Reporting Rollup, Portfolio, Portolio Strategy - Comes from Portfolio table
Portfolio Substrategy - Comes from Portfolio-ARM
I'm using a composite model here in order to avoid creating a separate data model since this dataset has all the fields I'm looking for.
My thoughts are to create disconnected slicers for the one highlighted in my screenshot. But is it then possible to associate them properly with the other slicers and Matrix visual?