Matrix updating but keep columns

Hi Back2Basics ,

According to your description, I create a sample.

In my understanding, when the date slicer select 2022/6/1, you also want to display Item C even though there's no value.

Here's my solution.

1.Create a new table, don't make relationship between the two tables.

Table 2 = VALUES('Table'[Item])

2.Create a measure.

Sales Measure =
VAR _V =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Date] = SELECTEDVALUE ( 'Table'[Date] )
                && 'Table'[Item] = MAX ( 'Table 2'[Item] )
        ),
        'Table'[Sales]
    )
RETURN
    IF ( _V = BLANK (), BLANK (), _V )

Put the Item from the new table in the matrix Rows and the measure in the Values, then checked the Show items with no data.

Get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.