Power BI Matrix does not show current month when using calculated flag for last 6 months
08:14 12 May 2026

Title:
Power BI Matrix excludes current month when using month-end date in columns

Body:

I have a Power BI Matrix visual.

My source table contains a date column called `report_date`.
Currently, the maximum date in the table is `12 May 2026`.

For display purposes, I created this calculated column and use it in the Matrix Columns area:

```DAX
Month_End =
EOMONTH('Table'[report_date], 0)
```

So dates from May are displayed in the Matrix as `31 May 2026`.

I need to show the last 6 months including the current month.
For this, I created this calculated column:

```
Last_6_Months_Flag =
VAR MaxDate = TODAY()
VAR StartDate = EOMONTH(MaxDate, -6) + 1
RETURN
IF(
'Table'[report_date] >= StartDate &&
'Table'[report_date] <= MaxDate,
1,
0
)
```

The flag works correctly in the table view.
Rows from May have value `1`.

However, when I use this filter in the visual filter pane:

```
Last_6_Months_Flag = 1
```

the Matrix visual only shows months up to April.
May is completely missing.

Expected result:

```
Dec 2025 | Jan 2026 | Feb 2026 | Mar 2026 | Apr 2026 | May 2026
```

Actual result:

```
Dec 2025 | Jan 2026 | Feb 2026 | Mar 2026 | Apr 2026
```

Why does the Matrix exclude May even though May rows have `Last_6_Months_Flag = 1`?

Could this be related to using:

```
EOMONTH('Table'[report_date], 0)
```

which converts May dates into `31 May 2026`?

matrix powerbi powerbi-desktop powerbi-custom-visuals