Show blank values in Matrix Visual

[DBA_BI]

Hello,

I have a matrix visual with following data,

Tasks	User 1	User 2	User 3	User 4	User 5
Administration	4	5		7
Programming		2	3	4	5
Mentoring	1			4
Optimization	3		2		5
Security		2	3	4
Support	1		3	4	5

And when i filter any particular tasks (say Administration or Mentoring)

The matrix visual would only show me Users with non blank values alone. Instead i would like to see all the columns(Users) irrespective of a value.

Any help on this is much appreciated

[DBA_BI · Accepted solution]

Thanks @ray_ux.

I did verify it and there are no blank values, isntead Users dont have any data to clock against the tasks. And when we filter the tasks using slicer, Matric Visual would show the columns with no values.

Anyway, the solution that worked for me is explained in the link below,

https://community.powerbi.com/t5/Desktop/Matrix-data-Show-empty-columns-when-filtering-like-a-date/t...

[ray_ux]

@DBA_BI drag the value into the filter panel and untick blank/null values and see if it solves the problem in the matrix visual as it might need cleaning.