Forum Discussion
Zack92
Helper III
Helper IIIHow to show all the dates?
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 ma...
Zack92Helper III
Helper IIIIrwan 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
IrwanSuper User
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.