Forum Discussion
Using Date Table Filtering by different relationships as slicer
Hey learning_dax ,
the challenge you are facing has a name - this is good 🙂 The name is roleplaying dimensions.
Your requirement can not be solved by using a single date table and inactive relationships, instead, you need multiple date tables (populating multiple slicers) . An introduction to this concept is given by this article: Welcome to Power BI theatre: Role-Playing Dimensions! - Data Mozart (data-mozart.com).Hopfully, this gets you started.
Regards,
Tom
Hey learning_dax ,
the challenge you are facing has a name - this is good 🙂 The name is roleplaying dimensions.
Your requirement can not be solved by using a single date table and inactive relationships, instead, you need multiple date tables (populating multiple slicers) . An introduction to this concept is given by this article: Welcome to Power BI theatre: Role-Playing Dimensions! - Data Mozart (data-mozart.com).
Hopfully, this gets you started.
Regards,
Tom
Hi Tom,
Thanks for the quick response! Great to know that this is a popular challenge & that there is ample information to find online! Thanks for the article, and I'll start researching on the topic. Thank you!