matrix table Column display even if value blank

[Anonymous]

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]

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]

I applied the measure no change to the columns and values. I still don;t see the blank values

[Anonymous · Accepted solution]

Resolved as below:

Created a new table with distinct column

Add relationship to the tables

created matrix table

[mahoneypat]

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

Regards,

Pat