Forum Discussion
Date slicer filter
Hi I am new to power BI. I am trying to create 2 reports with the same date slicer. I have a calendar table which is used as a date slicer(For eg:September1st-.September 31st) 1st report will retr...
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 |
