Need to create Date slicer

Question

Hi Everyone, My self Uday.&nbsp;I have 2 fact tables,&nbsp;1. Medical, 2. Pharmacy.&nbsp;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".&nbsp;Please, Help me with this Scenario.

rajendraongole1 · Answer

Hi&nbsp;Anonymous&nbsp;- 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.&nbsp;Let me know if above solution helps.

mitutorials · Answer

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 · Answer

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

syndicate_admin · Answer

Thank you, Let me check with the linked one.

Forum Discussion

Need to create Date slicer

4 Replies

Related content

Creating date slicer removes data

Creating a dynamic slicer

Can i use a measure selected in a slicer (created with field parameters) to create a rank?

Create Slicer

Creating ICMs via Activator