Forum Discussion
Filter a slicer using a cell in a matrix table
- Anonymous2 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.
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.
Thanks a lot, this was a good workaround!🙏