Forum Discussion
How to Hide rows in Matrix Chart using Parent Child Hierarchy
HI Anonymous,
It sounds like you want to achieve custom filter effects on the matrix based on slicer selections, right? In my opinion, I think the default filter effect is not suitable for your reuqrement.
For this scenario, you can try to create an unconnected table as the source of the slicer then write a measure express to achieve your requirement and apply it to the matrix visual level filter.
Applying a measure filter in Power BI - SQLBI
If you are confused about the coding formula, can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi Xiaoxin Sheng,
Applying a measure filter is not applicable for solving the issue I am running into.
Here is the link for the sample file:
Highly appreciated the help.
Yi