How to hide a row in Matrix based on selection of a multi-select slicer?

[yuching_chang]

Hi there

I have a multi-select slicer "Level", and a matrix with Collab Name, Description in Row, and Week in Column

And Description is always blank for Level 1

So when other levels are selected with Level 1, users will see many blanks under Description...wondering if there's any way or dax to hide row - Description when Level 1 is selected?

Some workarounds I've known and don't prefer unless there's no other way, considering user experience and future maintenance:

1. Drill up to only show Collab Name, and ask users to only drill down when Level 1 is not selected

2. Use Bookmarks

Thanks

[v-rzhou-msft]

Hi @yuching_chang 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[v-rzhou-msft · Accepted solution]

Hi @yuching_chang 

I think you want to hide description when you select level1 in Level.

Your requirement is to get a dynamic showing in description.

However your description is in your Matrix Rows, we couldn't add a measure in Matrix Rows.

Here I have some advice:

You can hide description column manually.

When you select Level 1, reduce the size of description by yourself.

Don't forget turn off the word wrap in column header and row header.

Or you can build a bookmark.

Best Regards,

Rico Zhou

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

[amitchandak]

@yuching_chang , For hiding you might have to use bookmarks

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive