Matrix visual: how to remove or hide any row with no end customer

[emma313823]

Hi All,

I have a dashboard connected to some data. There apparently are some rows that show no end customer or account manager. I'm sure it some issue in the data it is connected to, however until I figure out why on the data side, I do not want this showing as an option in filters (it shows 'blank'). It is not affecting any of my totals because when I export these blank lines...nothing is there at all in the spreadsheet for values.

I tried on the End Customer filter under the advanced filter and selected 'is not blank' and applied the filter. So this removed the blanks from view, but, it presents a problem when my team wants to look for an end customer. The lookup does not yield what they want. I need my team to be able to use the End Customer filter for looking up a specific customer and it appears that by choosing 'is not blank' under advanced that using basic filtering does not support single or multiple checkboxes to be selected. It appears that I can't hide the advanced filter after applying what I did either. And I can't lock the filter, otherwise, they can't access it at all.

Is there some way for the lines with 'end customer' that are blank to be completely hidden from view at all times, yet leave the filters available to function such that my team can continue to lookup a customer or group of customers by checking the box oor boxes as they want?

Emma

[v-shex-msft · Accepted solution]

Hi @emma313823

Perhaps you can add a measure formula with an if statement to check the current value and return tag. Then you can use this on matrix visual level filter to filter records.

Applying a measure filter in Power BI - SQLBI
Regards,

Xiaoxin Sheng