Forum Discussion
Analysis Services - date/integer backed member filters
Hi xsgao_pbi,
It seems that you are using Multiple-dimension datasource, right? If so, when you use import model, it will consider it as text or int, so you need to change its type in powerbi by modeling. If you use live connection, it should have column like date key.value which is your value column in database and it should be date, you could use this in slicer.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Most Valuable ProfessionalHi xsgao_pbi ,
try to create a separate Attribute in the Dimension witch based on the Date Column.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
I see your point of testing a date column backed attribute. But I did not create this SSAS database so not sure where to add one.
But in the existing case, it's an integer column backed attribute (key is integer, value is date) and I cannot see integer comparison operators. So I believe to create another attribute that is based on Date column won't give me the date comparison operators in Power BI.
daxCommunity Support
Hi xsgao_pbi,
It seems that you are using Multiple-dimension datasource, right? If so, when you use import model, it will consider it as text or int, so you need to change its type in powerbi by modeling. If you use live connection, it should have column like date key.value which is your value column in database and it should be date, you could use this in slicer.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.