How can I show Missing Column Values In Matrix table for Selected range date filter

[Anonymous]

I have two filter One for date range and second for Prodcut Name. If i selected all products then I am able to see the all days within the date range filter because all products haivng all days values.

if I applied filter on Product name some prodcut names not have all days in this case matrix table not showing all days within the date range filter.I have selcted  Show Items with No data option for cloumns but its showing all days from 1 to 31.

I need only 1 to 14 days if i selcted first range filter value in case if change filter value it need to show days for that range.

Final output should be like below.

Thanks in Advace if you share your views on this issue.

Regards,

Prasoona.

[Greg_Deckler]

@Anonymous - Try adding 0 to your measure.

[Anonymous]

Hi Greg,

Thanks you for the reply, its not wokring .

I have added zero value for measures still its not working, Is there any way to apply filter on that range in case if we enable Show Items with no data option for matrix table, please share me if any other approch we can do