Sync slicer for Selected Quarter and Year in first page should be in second page.

[AtulsDream]

Hello Team,

I have Dim_Period table which have a column i.e, Period_Desc which is combination of Qtr and Year (Ex - Q2 2020).

I have three pages in my report, In first page put Period_Desc in slicer, which will show all available values in slicer.

If we select any quarter from slicer eg: Q3 2022 in first page, In next page Slicer, it should show only three records - Q1 2022, Q2 2022, Q3 2022 (Selected Year and quarters less than selected quarter).

Please help here.

[AtulsDream]

Thank you @v-xuxinyi-msft , for the detailed information also your pbix file help me a lot to resolved the issue.

Thanks

[AtulsDream]

Hi @v-xuxinyi-msft ,

Thank you so much for detailed explaination, Will try the same and get back to you.

[v-xuxinyi-msft · Accepted solution]

Hi @AtulsDream 

After my testing, I found that if the field used in the slicer in the other page is the same as the one in page1, it won't work, if it's a different field you can achieve the effect you want.

Here's the test I did.

My sample:

1. Create a calculated column as follows

Period_Desc = "Q" & QUARTER([Date]) & YEAR([Date])

2. Create a calculated table as the slicer

Date = VALUES('Dim_Period'[Period_Desc])

3. Create two measures as follow

Measure1 = 
IF (
    SELECTEDVALUE ( 'Date'[Period_Desc] ) = BLANK (),
    1,
    IF (
        LEFT ( MAX ( [Period_Desc] ), 2 )
            = LEFT ( SELECTEDVALUE ( 'Date'[Period_Desc] ), 2 )
            && RIGHT ( MAX ( [Period_Desc] ), 4 )
                = RIGHT ( SELECTEDVALUE ( 'Date'[Period_Desc] ), 4 ),
        1,
        0
    )
)

Measure2 = 
IF (
    SELECTEDVALUE ( 'Date'[Period_Desc] ) = BLANK (),
    1,
    IF (
        LEFT ( MAX ( [Period_Desc] ), 2 )
            <= LEFT ( SELECTEDVALUE ( 'Date'[Period_Desc] ), 2 )
            && RIGHT ( MAX ( [Period_Desc] ), 4 )
                = RIGHT ( SELECTEDVALUE ( 'Date'[Period_Desc] ), 4 ),
        1,
        0
    )
)

Page1:

Put the measure1 into the filter so that the visual only shows data where the measure1 is equal to 1.

Setting up a synchronized slicer

Page 2:
Put the measure2 into the filter so that the visual only shows data where the measure2 is equal to 1.

Result:

When I select the slicer for page1, the effect of page2 is as follows:

Best Regards,
Yulia Xu

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