Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
CatoD
Frequent Visitor

Show default month if nothing is selected in month slicer

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?

1 ACCEPTED SOLUTION
CatoD
Frequent Visitor

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.

View solution in original post

3 REPLIES 3
CatoD
Frequent Visitor

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
Solution Sage
Solution Sage

Have a look here to see the technique to implement. 

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

CatoD
Frequent Visitor

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors