Relative Date Filter - Analysis Services Live Connection

[mthirty]

Hello,

I am wondering if it is possible to use the Relative Date filter options when connecting Live to a SQL Server Analysis Services data source? If so, what are the field settings I need to establish in SSAS to make this feature available?

Thanks!

[v-easonf-msft · Accepted solution]

Hi ， @mthirty 

If you use the "Connect Live" option to connect to the data model(my model is a Tabular project not MultidimensionalProject), make sure the type of your date is "date" not " text" in SSAS. 

Best Regards,
Community Support Team _ Eason

[mwegener]

Hi @mthirty ,

check this out.

https://community.powerbi.com/t5/Desktop/Date-slicer-filter-doesn-t-work-with-dates-from-SSAS-Cube/m...