How to show all the dates?

[Zack92]

Hello,

I have a matrix table with dates as column headers, but some dates are missing. I really want to display all the dates, even if there's no data for some of them. Any ideas on how I can make this happen?

Thank you

[Zack92]

@Irwan  Thank you for the response, I've got this filter set up for August, but there are a couple of days missing - like the 20th and the 22nd because there's no data for those days. The thing is, when I use your method to show items with no data, it just throws away the filter and shows me everything, all the dates, and I just want to see what's happening this month. I am not sure why it does ignore the current month's filter 

[Irwan]

hello @Zack92 

if visual filter as my reply above doesnt work, then it might need another measure.

this post looks like have the same problem.

Solved: Visual filter disable after "Show items with no d... - Microsoft Fabric Community

Thank you.

[Zack92]

@Irwan 

Thank you for the quick repose, when I do that it will show me all the dates even though I have a filter current month.

Any idea why is that? 

[Irwan]

hello @Zack92 

try to do visual filter on this visual instead of in this page. let see if that solve the issue.

here is an example of what i usually do, visual filter because i only want to filter certain visual (not the page)

Thank you.

[Irwan]

hello @Zack92 

select your down arrow in column value, there should be an option "Show items with no data". If there is no option in Date, it might be in down arrow in 'OffDays'.

Hope this will help you.

Thank you.