Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am connecting to SSAS Tutorial database. After draging a date backed (date column as key) member into filter and selecting advanced fitler, I still see string operators (starts with, contains, etc.). Is that possible to use date comparison operators (before, after, between, etc.) to filter date members? Also, can I use numeric comparison operators (less than, between, etc.) to filter integer backed members?
Solved! Go to Solution.
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 Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @xsgao_pbi ,
has your question been answered?
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @xsgao_pbi ,
I don't know your ssas toturial database, but if the columns have the correct data type, the filters should be available.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @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.
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 Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |