Forum Discussion
Matrix visual goes blank upon slicer selection
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:
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
Good morning Pat,
Yes, just verified that - I have data for all possible combinations of filter selections. Thank you!