Forum Discussion

learning_dax's avatar
learning_dax
Helper II
3 years ago
Solved

Using Date Table Filtering by different relationships as slicer

Hi all,    I've created a DimDate table based on many different calculated columns. I have custom Fiscal Year & Fiscal Quarter columns to parse out the reporting based on Fiscal Calendar rather tha...
Need Help
Show and Tell
TomMartens's avatar
TomMartens
Super User
3 years ago

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

  • learning_dax's avatar
    learning_dax
    Helper II
    3 years ago

    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!