Matrix visual - how to always show all columns, regardless of filters

[Anonymous]

Hi.
I need to show a montly overview of activities, and which day in month a particular activity is ongoing.

I have the following requirment:

- Need to create something similar to Gantt chart

The Custom made Gantt chart have these requirements:

- Must use Matrix Visual

- "Activity name" as rows ("Implement project X", "Fix bug y")
- "Date in month" as columns (1,...,31) 
- Always filtered by 1 specific year and month (e.g. Month=August, Year=2023)

 
The following problem occurs - some columns are not shown, depending on the filters applied to the data. 

For this particular use case:
In months where there are days ("Date in month") without any ongoing activity: the columns for this dates are not shown.
The illustration below shows current situation (days "16,...,19" not shown) and goal.
Assume the data is filtered on Month=August, Year=2023.

To summarize the question: Does anyone know how to make sure all columns always is shown for a matrix visual?
Regardless of filters on the data.

In this case, how to make sure all days in a particular month is shown, regardless of which date there is an ongoing activity?

All help is much appreciated  

Sample data:
Date table DimDate defined as:

DimDate = 
 ADDCOLUMNS(
    CALENDAR(DATE (2021, 1, 1), DATE (2026, 12, 31)),
    "Day in month", DAY([Date])
 )

Table Activity:  

Activity name	Start date	End Date
Plan project	01/08/2023	05/08/2023
Implement task	01/08/2023	15/08/2023
Fix bug	20/08/2023	31/08/2023
Long going project	01/01/2023	31/07/2023

[Anonymous]

"Show items with no data" solved the problem
So simple.
Thank you

[Syk · Accepted solution]

Have you tried the 'Show items with no data' checkbox?