Matrix table, show all months and quarters in selected period

[m4xon]

Hi, 

I have following issue, I need to show based on user selection next 5 quarters (including months even if there is no data).

So for example, user is selecting 2024 Q1 and matrix table should show next 2024 Q1, Q2, Q3, Q4, 2025 Q1 with months. 

I have a measure which limits the data to this period quite efficiently, but another problem has arisen, namely that if there is no value for a given row it is supposed to disappear, so based on below example there shouldn't be 0 and I have no idea how to achive it.

MEASURE = 
VAR _min = MIN ( dimSource[DEL_START] )
VAR _max = MAX ( dimSource[DEL_END] )
VAR _result =
    IF (
        MIN ( 'dimDate'[Date] ) >= _min && MIN ( 'dimDate'[Date] ) <= _max,
        IF ( MIN ( dimSource[Delivery Date] ), 2, 0 ),
        BLANK ()
    )
RETURN
    _result

When I tick "show item with no data", then I see all quarters and months, and I don't know how to limit them:

Thank you in advance for help

Max

[v-kaiyue-msft · Accepted solution]

Hi @m4xon ,

Thanks for the reply from @3CloudThomas , please allow me to provide another insight: 

You can change the data to be displayed as 0 to blank.

For example, the following example.
When the result is 0, all rows and columns are displayed.

When the result is blank, rows and columns with no data are hidden.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[3CloudThomas]

Maybe you go back to the ones requesting this and ask why show quarters if there is no data.

[m4xon]

your help is not very helpful 🙂

[3CloudThomas]

Instead of using the min and max in the measure, use a slicer on date with the relative option. Also, instead of BLANK(), use a value like -1 or 0

[m4xon]

i cannot have slicer on date at that page and when I will use 0 instead of Blank then I will see the tables as below, so how it could help?