I've got an SSAS tabular model with a column that hold date values. The SQL column is of date type. On the SSAS side, the column data type is Date.
However, when connecting to the model from Excel, I am unable to see date filter option when I click on date column as which I have mentioned below
I can see only below options when i click on date column in pivoted table.
label filter
value filter
Rows in date column have been considering as text even changed data type and date format as date in ssas model.