Forum Discussion

aliawais's avatar
aliawais
Frequent Visitor
4 years ago

Adding Date Slicer using Multiple Date Columns

Hi All,   I'm trying to add a Date Range Slicer to my Power BI Report so every week when i'm producing 4 weeks lookahead report i just have to change dates using date range slicer. I have 5 differe...
Need Help
Show and Tell
aliawais's avatar
aliawais
Frequent Visitor
4 years ago

Hi,

 

Thanks for your response. You are right after unpivoting my table I'm able to use the value column as desired date range column without even creating a calendar table. But to do so I'm not able to set up my visual as per project requirements.

You mentioned that linking Calendar Table to the value table is a solution. Is there any way we can link calnedar table to all of my 5 date columns? I have read some where it's possible but i need to write a code for multiple relationships at one time as Power BI only allows one relationship active at a time.

Do you have nay idea how to do that?

 

Thanks Alot 🙂

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

You are welcome.  You can have only 1 active relationship between 2 tables.  More relationships can be built but they will have to be inactive.  The USERELATIONSHIP() function can be used in DAX formulas to activate the inactive relationships.  I can offer more help if you share some data, describe the question and show the expected result.