Show default month if nothing is selected in month slicer

[CatoD]

Hi,

Context:

My model contains date dimension table - dDate

The matrix visual has months in columns, so in default view, there are 12 columns.

The default view however, must show only one month - e.g. April. 

To do that I have created calculated column in dDate table:

_isAvailable = 
VAR _year = 2024
VAR _month = 4
RETURN
IF(
    dDate[Year] = _year && dDate[Month Number] = _month
    , 1
    , 0
)

Now in matrix visual, i have changed Month column to show 1 TopN element based on _isAvailable column.

The default view shows correctly the month I want.

But now there is an issue, when I choose in month slicer, e.g. months April, May and June, the visual shows only April (because of isAvailable column).

How can I modify calculated column or create other measure which will solve the issue?

[CatoD · Accepted solution]

I have managed to solve the issue:

In matrix visual, you have to change the column which is used as period e.g. 'month + year', than create measure:

IF(
    ISFILTERED(dDate[M. + Month Number]) //the column used as slicer - other than column used in matrix table
    , 0
    , MAX(dDate[_isAvailable])
)

Now in matrix visual, change filter for 'month + year' column to show 1 TopN element based on above measure.

[Alex87]

Have a look here to see the technique to implement. 

https://gorilla.bi/power-bi/set-default-slicer-value/

[CatoD]

Thank you for reply, but unfortunately it is not what I was looking for