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
Super 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

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

 

 

  • lbendlin's avatar
    lbendlin
    Super 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.