Applying a filter(slicer) that will only effect parts of the dataset.

[acamar22]

I have production and failure data that I am analyzing. I have appended the seperate queries into 1 to better work with (see previous post). I added a column that labels the data as either production or failure data. I've now run into a seperate issue. 

The failure data contains customer information, while the production data does not. Therefore, in the combined query, the production data's customer information is null.

I now want to add a customer slicer that will effect the failure data ONLY: the production bar graph should not change when filtered. However, since it's technically null, the production data gets filtered out.

Please help! Thanks guys

[Ashish_Mathur]

Hi,

I am unable to understand your requirement.  Share both tables in a format that can be pasted in an MS Excel file and show the expected result in a Table format.

[lbendlin]

change your filter from 

[column] = "criteria"

to 

[column] in {"criteria",BLANK()}

[acamar22]

Hi again @lbendlin 

Thanks for the help, are you suggesting to select both BLANK() and the criteria? that would work but would be confusing to the users.

Maybe I'm misunderstanding. Is this a measure I would add to the filter? Can you provide a link to explain the process if you have one?

[acamar22]

Hi @lbendlin

I'm not entirely sure what you mean here. Can you elaborate please?

[lbendlin]

I now want to add a customer slicer that will effect the failure data ONLY: the production bar graph should not change when filtered. However, since it's technically null, the production data gets filtered out.

i proposed an approach that would deal with that premise.