Need to create Date slicer

[Anonymous]

Hi Everyone, My self Uday.

I have 2 fact tables, 1. Medical, 2. Pharmacy. 

I have "Diagnosis_Date" and "Paid_Date" in Medical table and, "Date_Filled" and "Paid_Date" Columns in Pharmacy table.

Combing "Diagnosis_Date" column from Medical and "Date_Filled" column from Pharmcy is "Service_Date" and,

Combining "Paid_Date" column from Medical and "Paid_Date" column from Parmacy is "Cleared_Date".

I need Slicer in report to filter "Service_Date" and "Cleared_Date".

Please, Help me with this Scenario.

[miTutorials]

I'm assuming that you want to filter both the columns using one slicer ?? If yes please see the below tutorial.

Filter Multiple Columns using a Date Slicer in PowerBI | Trick to Filter MiTutorials 

[Syndicate_Admin]

Thank you, Let me check with the linked one.

[rajendraongole1]

Hi @Anonymous - I think you may create one common date table and give the relationship with existing any date field and check the filters on above dates.

Let me know if above solution helps.

[Syndicate_Admin]

Yes, I tried the same.. But It's not happening. Thank you