Forum Discussion
Filtered measures through slicer
Hello again, I have a set of data that gives me one reservation slot on a specific date and its status (reserved/ not reserved) for every row. One day features multiples reservation slots. My ...
I'd need to see the data model, but a few things:
- Ensure you have connected the Date[Date] field to the Date field in the fact table in the relationship view.
- Ensure the date types are the same. I've been in a hurry and left a date as text, so visually it looked like "12/31/2020" but that is not a date and date calcs and slicers won't work. I would make sure they are both Date format, not date time or anything else.
- Ensure the slicer is, in fact, the date table date, not the fact table date.