Forum Discussion
Date slicer filter
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.
This is the page which filters according to Sept1-30th.
Now I need to filter the data from the same table in which the 1st page was generated but before sept1st.
