Forum Discussion
Show blank values in Matrix Visual
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
Thanks RayWu.
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,
2 Replies
Thanks RayWu.
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,
