How to connect to different dates in the fact table with a single date slicer?

[jiby]

How to connect to different dates in the fact table with a single date slicer? So that the visuals in the page need to be refreshed  according to the date selected. For  e.g If i select the requested delivery date, I want to see the Pending and Not Due orders, whereas when I select the Despatch Date, delayed and On Time Orders need to be shown in the visuals

As of now I am only able to connect One date to the date slicer either Requested Delivery Date or  Actual Despatch Date .

How to solve this?

[Anand24]

Hi @jiby ,
Step 1 - Create a date dimension table and connect/join its date to Requested Delivery Date and Actual Despatch Date

Step 2 - If possible, make the filtering direction uni-directional such that date dimension filters out other 2 tables Step 3 - Now take only this date from date dimension table into slicer

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn