How to ignore filter in matrix

[kevderbeste]

Hi everyone, Iam searching the way to keep ignoring filtering the rows and columns on my matrix. 

In this case, when i filter by date, the matrix is filtered and then disappear some columns or rows.

Example

 

[kevderbeste · Accepted solution]

Thanks all for you information, finally i found the wat. In order to still having the measure's null values, i created a calculated measure with this sintax 

measure = if(isblank(count(id)), 0, count(id))

And with this i can still seeing the null values, but with 0, and the values of the header columns and header rows still ¿appering no matter the value been null

[amitchandak]

@kevderbeste ,Not very clear

if the object, subject are values of the dimension.

then you can try this option

[kevderbeste]

Hi, thanks for the information, i tried but is not the solutión. 

I need when i filtered the matriz, the measure null values still appearing in order to the columns and rows dont dissapper. 

Thanks. 

[BA_Pete]

Hi @kevderbeste ,

If you don't want your matrix to ever be filtered by slicer selections then you can select your slicer, go to the View (I think) tab, select 'Edit interactions', then select the little stop sign that shows up above you matrix when you hover over it. Rinse and repeat for each slicer that you do not want to affect this visual.

Pete

[kevderbeste]

Hello, thank you for the information. But in this case, I need the matrix measure to respond to the segmentation filters implemented in the dashboard, and that the dimensions in the rows and columns make the filters fat.