cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yuching_chang
Helper II
Helper II

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

Hi there

 

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

Capture3.PNG

 

And Description is always blank for Level 1

Capture4.PNG

 

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

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

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.

2.png

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. 

 

View solution in original post

3 REPLIES 3
RicoZhou
Community Support
Community Support

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

RicoZhou
Community Support
Community Support

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.

2.png

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. 

 

View solution in original post

amitchandak
Super User IV
Super User IV

@yuching_chang , For hiding you might have to use bookmarks

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.