How can I use synced slicers (slicer group) to set the default to last month?

[Anonymous]

Hi!

I trying to use "Advanced slicer syncing" to set the default value to last month for a year-month slicer.

I trying to do this by having another date-slicer set to relative, Month(Calender) and last 1.

By placing both slicers within the same slicer groups they are supposed to sync.

The goal is to have a Year-month-slicer, pre-set to the last month, but then the user should be able change to an earlier month if needed.

The data-source is a tabular-cube, so I am somewhat limited on how I can change the model. Adding measurs is possible, but not changing dimension-columns.

Any help is most appriciated!

[v-frfei-msft · Accepted solution]

Hi @Anonymous,

Here I made one sample for your reference.

Measure =
IF (
    YEAR ( MAX ( Table1[date] ) ) * 100
        + MONTH ( MAX ( Table1[date] ) )
        = YEAR ( CALCULATE ( MAX ( Table1[date] ), ALL ( Table1 ) ) ) * 100
            + MONTH ( CALCULATE ( MAX ( Table1[date] ), ALL ( Table1 ) ) ),
    1,
    0
)

Then we can get the result as we excepetd. Here we need to filter the table visual by the measure.

For more details, please check the pbix as attached.

Regards,

Frank

[Anonymous]

Hi!

I have tried your example file. Thanks again for providing it. Clicking the measure does filter the visual.

But I cant see that the slicer sync has any effect. One of the slicer is i a group called "Group", but the other slicer is not in the same group, so they are not synced.

I am missing something?

[Anonymous]

Thanks! I will check out the pbix-file 🙂