Forum Discussion
Year as a Dimension
I am creating a shared dimension model where I have 3 Fact tables and 2 Dimensions. Both the dimensions are shared by all 3 Fact tables.
I have a date dimension table in the in the source that I have pulled into power bi. However, the fact tables do not have a date key but only a year column. In the visual, I would like to filter the fact tables by year.
The relationship between Year Dimension and the Fact table becomes a many-yo-many as there is no date key.
What is the best way to handle this scenario ?
1. Can I convert the years in the Fact to a date (may be 1/1/2023 where year is 2023), so that I can have a one-to-many relationship?
2. Have a many-to-many relationship between the Fact and Dimension (filter direction in this case ?)
1 Reply
- Ashish_Mathur
Super User
Hi,
Implement your first suggestion.