Forum Discussion
Hide specific rows in matrix
Hi everyone,
I am building a matrix in Power BI and am wondering if there is a way I can hide specific rows that are blank. I switched my values to rows and would like to hide two value rows called Supply and Forecast from certain sections in my matrix where they are not populated but keep them in other sections where they do have a value attached. In my case, these values are populated under Product B in my matrix but are not populated under Product A.
I tried putting a filter on the visual to only show Supply and Forecast when they are not blank but then that hid almost my whole matrix instead of those specific rows only.
I would like to find a way to hide the Forecast and Supply rows under Product A while at the same time keeping the Forecast and Supply rows under Product B.
Any help/insight would be greatly appreciated. Thank you!
- Anonymous1 year ago
Here are the steps you can refer to :
We can search the "Text wrap" attributes for this Matrix visual and then we can close both of this "Text wrap" .Then we can drag the column which you do not want to display it to hide :
Solved: Matrix - Hide a column in visual but consider in c... - Microsoft Fabric Community
Solved: Re: Matrix values issue - Microsoft Fabric CommunityBest Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- AnonymousNot applicable
Here are the steps you can refer to :
We can search the "Text wrap" attributes for this Matrix visual and then we can close both of this "Text wrap" .Then we can drag the column which you do not want to display it to hide :
Solved: Matrix - Hide a column in visual but consider in c... - Microsoft Fabric Community
Solved: Re: Matrix values issue - Microsoft Fabric CommunityBest Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.