Forum Discussion

Sunflower7500's avatar
1 year ago
Solved

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!

1 Reply