Forum Discussion

VikasNegi's avatar
VikasNegi
Frequent Visitor
3 years ago

Power BI Matrix Visual to be Filtered by Multiple Slicers - Design Guidance

Hi Guys,   I'm quite new to Power BI and need some guidance on developing a Power BI report based on multiple slicer selections.   I have the below data model -   Holdings - Security -> Have a ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

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.

  • VikasNegi's avatar
    VikasNegi
    Frequent Visitor
    3 years ago

    @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?

  • VikasNegi's avatar
    VikasNegi
    Frequent Visitor
    3 years ago

    Hi lbendlin - Hi did remodeling and created two disconnected slicers. Can you look at the below issue please

     

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      instead of "IN" you should be able to use TREATAS.  If you know that the measure may return BLANK, use COALESCE to provide an alternative result.