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.
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.