Forum Discussion

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 items with no data is checked). Still i am not able to see the blank data for the column.

Anonymous
5 years ago
Resolved as below:

Created a new table with distinct column
Add relationship to the tables
created matrix table

4 Replies

mahoneypat
Microsoft Employee
5 years ago
Did you try adding "+0" to your countrows measure?

Regards,

Pat
Anonymous
Not applicable
5 years ago
Hi Anonymous - This blank seems missing from the dataset because 'Blank' is not a tangiable value. You can try below 2 ways:
1.) If this is coming from SQL table/View Try Something like
SELECT ISNULL(myColumn, 0 ) FROM myTable
2.) Create a new Measure and Add 0 to the value, Something like:
myColumn +0
And use this new Measure in your matrix visual.

Hope either of this will be helpful

Cheers,
-Namish B
- Anonymous
  Not applicable
  5 years ago
  I applied the measure no change to the columns and values. I still don;t see the blank values
  - Anonymous
    Not applicable
    5 years ago
    Resolved as below:
    
    Created a new table with distinct column
    Add relationship to the tables
    created matrix table

Related content