Forum Discussion
Date slicer filter
Hi SUN_19
From what I understood, you are looking for Sync Slicer
Please ref this article - https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-desktop
If you looking for Sync Slicer, please note Sync Slicer is only working on one pbix file with multiple pages. It will not work with a separate PBIX file.
Please correct me if I wrong
If resolve your requirement, please mark this answer as SOLUTION.
Thanks
Pijush
Dear Pijush,
Thabks for the reply.
I tried with sync filters but that will give only filter with september in all pages. But I need to retrieve the details before september from the same table. Hope you understand my problem.
I don't think I'm understanding either. Can you please provide some sample data and screenshots of your model and report pages to better illustrate your requirement.
Please find the below table which I need to filter according to the calendar table given as slicer. FIrst report is showing correct which gives according to the filter given ie Accounting date ranges between the slicer date will filter and generate the data.. Now I need to filter the same table but the data should be before the date in the slicer. For eg: If I have given date as 01/09/20223-15/09/2023. Ist report will generate 1st line only and 2nd report should generate only 2nd line.
Purchase requisition table AccountingDate ItemNumber RequisitionNumber LineDescription RequisitionLineNumber DeliveryAttentionInformation 01/09/2023 AB09 1956 Testing Services 1 28/09/2023 AG789 1988 Skilled Labour 2 When you say "report," do you mean different pages within the same power bi file? Or do you mean 2 table visuals on the same page? Send a screenshot of your report please.
