Matrix Visual - how to keep rows and columns in place with an active slicer

[Anonymous]

Hi everyone,

I have a database in which risks are always ranked on the probability that it will occur (1-5) and the impact it will have on the organization if it occurs (1-5). I have now created a matrix, showing the number of risks in a certain impact-probability combination. It looks like this:

The red and green squares behind the matrix is an image I found online so it looks a bit structured. It is not a conditional formatting of the matrix itself. Bottom left is the combination 1 - 1, top right is the combination 5-5.

The problem I now have, is that the dashboard has more information information available next to this matrix and the user has slicers to play with. Two of those slicers are 'Impact' and 'Probability'. If the user slices for example on probability = 4, then the matrix looks like this: 

The same problem occurs when slicing on the impact (e.g. Impact = 3):

What I want however, is that the matrix shows blank or 0 values for the rows without data and the data is filtered in the correct column. In the above example, I want the data for probability = 4 to be shown in the fourth column so that it still matches the image behind it.

Does anyone know how to solve this?

[Anonymous]

Hi @Anonymous ,

You want to filter with a slicer, and then the columns in it stay where they are, right?

Unfortunately, this is currently not possible. You may submit an idea and vote for it: https://ideas.powerbi.com/ideas/.

Best Regards,

Stephen Tao

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

[Anonymous]

Thanks for the response Stephen!