Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filter a slicer using a cell in a matrix table

Hi everybody,   I was wondering if there is any way in which a table may filter a slicer: so, for example, if I select a cell in a matrix visual, would it be possible to have the slicer filtered on...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    Power BI doesn't support filtering slicers using selections in the matrix. Because the slicer is the source of the filter, not the target.

     

    However, you can achieve a similar effect by using the following workaround:

     

    Create a measure in your data model that calculates based on the selected value in the matrix. This measure will reflect the current selection in the matrix.

     

    Place that measure onto a card visual or another appropriate visual on the report page.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.