Make filters match on different pages

[mladird]

Hello,

I have 2 pages :

• 1 for my actuals with the following filter:  
• 1 for my "year to date" with the filter (Year to date up to month 3, YTD up to month 6, and so on) : 

I've created a graph on my Actuals page that is working perfectly fine, but that is not working for YTD. The thing is for my filter in Actuals i have 2 level (quarter, month), and for my YTD page i have only 1 level (the YTD for each quarter). 

Is there an (easy) way that when I click on YTD 3 for instance it gives the exact same graph as if I've would I have clicked on quarter 1 on my "Actuals" page ? (and the same goes for YTD 6 > Quarter 2, YTD 9 > Quarter 3, YTD 12 > Quarter 4) ? 

Thank you

[Anonymous · Accepted solution]

Hi @mladird ,

Based on the description, go to the view tab and select sync slicers.

Then, select the YTD slicer. Choose the sync and visible.

Select the YTD and the table visual in actual page is quarter 2.

Best Regards,

Wisdom Wu

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

[dharmendars007]

Hello @mladird , 

I'm not sure YTD DAX you have used..But based on the slicer you are mentioning, You can try this below YTD measure it will work for all slicer you select.

CALCULATE([Your Measure],

                            FILTER(ALLSELECTED('Date Table'),

                                'Date Table'[Date] <= MAX('Date Table'[Date])))

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[mladird]

For YTD, there is no DAX formula per say as there are already predetermined in the excel file i have collected my data from.