Matrix visual goes blank upon slicer selection

[mstone3]

Hello, I have a matrix style visual with the rows populated with a 3 level hierarchy (e.g. Level 1 = State, Level 2 = School District, Level 3 = School).  The matrix is synched with a slicer using Level 2/School District as the level.  

When the matrix is drilled down to level 3 and the level 2 slicer selection is changed, the entire matrix goes blank.  The matrix can be restored by drilling up one level.  Interestingly, this doesn't happen when the matrix is drilled to level 2 and the level 2 slicer selection is changed - only when the matrix is drilled to level 3.  Is there any way to prevent the visual from going blank?

Thanks!

[mstone3 · Accepted solution]

Okay I figured it out!  Here is a solution for anyone experiecing the same issue:

When the level 2 slicer is toggled, the settings of the level 2 filter on the matrix (viewed from the filter pane) need to be selected for all level 2 options.  In default configuration shown below, only one of the two options is checked, so this seems to explain why the visual goes blank when the slicer is toggled to the other (unchecked) option:

Checking both options as shown below solves the issue and the matrix no longer goes blank when toggling:

[v-yangliu-msft]

Hi  @mstone3 ,

You can check the following, whether there is a null value in your data, it will show that there is no blank.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[mstone3]

Hello - thanks very much for your reply!  Apologies for the delayed response.  I've inspected the data for blanks/nulls and made sure there were none.  I can provide some additional information and screenshots below:

For the fact table, I have student records where each row equals one student and the fields are student number and school code.  Example:

For the dimension table, I have fields to relate the school code to state (level 1), district (level 2) and school (level 3). Example:

The dimension table contains a created hierarchy field with school nested within school district nested within state: 

The dimention and fact table are related one to many.

For the visual setup, I have a matrix with the hierarchy placed on the row and the distinct count of student number as the value (nothing added to columns).  I also have a slicer with level 2 (school district) as the field.

I have the matrix drilled to level 3 on the hierarchy as shown above.  But when I switch the district from upstate to district on the level two slicer, the matrix goes blank:

For the user experience, I would like to to not go blank and instead show the level 3 results on the matrix for the new level 2 slicer setting:

I can get the correct result changing the slicer (visual goes blank), then drilling up to level 2 then back down to level 3 on the matrix, but would prefer the user not have to do this.

Thanks so much for any help you may have!

[mahoneypat]

Have you confirmed in the Data View when you make those same filter selections (choose one school code you know exists in that Level 3 selection) that you have rows of data?

Pat

[mstone3]

Good morning Pat,

Yes, just verified that - I have data for all possible combinations of filter selections.  Thank you!