Hide specific rows in matrix

[Sunflower7500]

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!

[Anonymous · Accepted solution]

Hi @Sunflower7500 

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 Community

Best Regards,

Jayleny

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