Assistance on DAX

Hi lavankumar1989a ,

If you want to filter multiple visuals in this way, I think it is more convenient to create a direct correspondence between the date of the slicer and the date to be filtered. Try the following cade in Power Query:

let
    Source = Table.FromValue(#"Table"[Date], [DefaultColumnName = "Slicer_Date"]),
    #"Removed Duplicates" = Table.Distinct(Source),
    #"Added Custom" = Table.AddColumn(#"Removed Duplicates", "Table_Date", each List.Dates([Slicer_Date],7,#duration(1,0,0,0))),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Table_Date")
in
    #"Expanded Custom"

Then create * : * relationship between Table and Slicer table.

Add Slicer_Date column to the slicer on page1, and synchronize slicer to other pages.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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