Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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
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.
@yuching_chang , For hiding you might have to use bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |