Forum Discussion
Drive / change slicer selection based on value selected from a matrix
- Anonymous9 months ago
Hi punitpopli ,
Thanks for the additional details.. The behaviour you are trying to replicate from Qlik where a selection inside a matrix updates the slicer and filters other visuals is not supported in Power BI. Measures cannot be used as filters, and visuals cannot push their selections back into a slicer or override its value.
Because of this, clicking a product in the Cost matrix cannot drive both matrices or change the slicer selection. The closest supported alternatives are using disconnected slicers, drill-through, or separate detail pages.
If this approach does not meet your requirement, please share a small sample dataset and the expected behaviour so we can help suggest a workable Power BI design.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Want faster answers? How to Get Your Question Answered Quickly - Microsoft Fabric CommunityHope this helps. Please feel free to reach out for any further questions.
Thank you.
Hi punitpopli ,
Thanks for the additional details.. The behaviour you are trying to replicate from Qlik where a selection inside a matrix updates the slicer and filters other visuals is not supported in Power BI. Measures cannot be used as filters, and visuals cannot push their selections back into a slicer or override its value.
Because of this, clicking a product in the Cost matrix cannot drive both matrices or change the slicer selection. The closest supported alternatives are using disconnected slicers, drill-through, or separate detail pages.
If this approach does not meet your requirement, please share a small sample dataset and the expected behaviour so we can help suggest a workable Power BI design.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Want faster answers? How to Get Your Question Answered Quickly - Microsoft Fabric Community
Hope this helps. Please feel free to reach out for any further questions.
Thank you.
- lbendlin8 months ago
Super User
Measures can be used as visual filters.