Hide or Show Matrix table row header based on filter selection

[NSC7]

Hi All,

I have a matrix table as shown below. Prod, Dept, Dept  head and Source are row header.

I have switched off Stepped layout to show the data in below format.

I have a requiremnt to hide/show column Dept and Dept head based on the filter. Show the column when user will select Show Dept as Yes and hide when user will select No.

Thanks

[v-yueyunzh-msft · Accepted solution]

Hi , @NSC7 

Hi, @NSC7 

According to your description, you want to have a slicer to control the fields on the row headers.

Here are the steps you can refer to :
(1)This is my test data:

(2)We can create a field parameter in Power BI Desktop:

(3)Then we can put the [Parameter] on the row header and we can also have a slicer on it , like this:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[NSC7]

Thanks , It helped.

[vicky_]

I would suggest adding in a field parameter and using that in the visual. So then the user can select which level of the heirarchy they want to show up. Check out the following tutorial that I find pretty helpful: https://www.sqlbi.com/articles/fields-parameters-in-power-bi/