How to exclude matrix columns for which the value is blank?

[YunJ]

Hi,

For Sub-category="Brush","Bronzer","Lip Liner", there is no "MS" measure for them. So I want to exclude them.

Basically I would like to write a measure to exclude sub-category for which the MS value(for all the stores) is blank.

Thanks for your time.

[MFelix]

Hi @YunJ ,

There is no option to do this directly you can shrink the columns until they are not visible.

[YunJ]

Hi @MFelix @amitchandak 

Thanks a lot for your reply. I'm wondering why it does not work if I set "MS is not blank" in the Filters Pane?

[amitchandak]

@YunJ , because unpivot has created that and it kind of uniform display.

[amitchandak]

@YunJ , I doubt there is an option in the current matrix visual.