Forum Discussion
FIlter Data Based On Slicer Selection
I have data table with sales products by day for the currrent quarter [tblSales] InvoiceDate | Product | Qty Sold I have a table that has date period selections [tblDateSelections] Date Period | ...
This solution would only give me a 1 or 0 for that date period. I have columns within the tblSales that flag each date range already eg WTD-Flag, MTD-Flag etc. In an ideal world what I want to do is;
- select a date range period from a slicer which is populated from a table with all the date range selections
- this selection to then change a value in a column called MasterDate-Flag within tblSales which would update all relevant records within this column to a 1 or 0 dependant on the date period selected
- this column would then be used as filter criteria for the report, page or visualisation
Hope this makes sense and thanks for the proposed answer.
Cheers
dramus
Continued Contributor
Continued ContributorLet me see if I can restate the problem, to see if I understand.
You want a column on the Sales data that shows whether this record has been selected based on the filtered values in the Dates table?