Forum Discussion
Date column value not appearing in axis section
My issue was with the relationship filter. It should have been cross filtering, not single. This solved my problem.
Microsoft EmployeeAnonymous
In Power BI Service, when we connect live to Analysis Services (no matter Azure or On-premise), we can't do any transform on data field. And it will not automatically generate the date hierarchy for date field. So you'd better create a date hierarchy within SSAS project and deploy.
Also if you have set NameColumn for attribute it will resolve both key column and name column into two fields. The name column is text type.
Regards,
Hello v-sihou-msft,
I guess I'm a little confused where the date hierarchy should be added within the SSAS model, should it go on the primary or foreign key table? I'm thinking the primary key table which I've added a date hierarchy named 'calendar' to my date table within SSAS as month/day/year columns as shown below, then deployed the model:
After that, I refreshed my Power BI and come up with the following:
The values are still not correct as they should be unique per year, just like in the local csv model.
Thank you again
My issue was with the relationship filter. It should have been cross filtering, not single. This solved my problem.