Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

matrix table Column display even if value blank

I have a matrix report as below ( rows : group, columns : hours and value : measure field( count of rows)). The column hours are missing if i have blank value. I verified right click on Hours ( Show ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Resolved as below:

     

    Created a new table with distinct column

    Add relationship to the tables

    created matrix table

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Did you try adding "+0" to your countrows measure?

Regards,

Pat