Hello everyone, I have a case like this:

I have a 2 tables:

- Table 1: named "Dile_fact"

Name	Date_exam	Date_release	Units
Ava	01/15/24	11/01/24	Meter (m)
Leo	02/20/24	11/15/24	Kilometer (km)
Mia	03/10/24	12/05/24	Centimeter (cm)
Zoe	04/25/24	12/25/24	Millimeter (mm)
Jaxon	05/30/24	01/30/24	Inch (in)
Clara	07/04/24	02/14/24	Kilogram (kg)
Asher	08/21/24	03/22/24	Gram (g)
Nia	09/15/24	04/07/24	Pound (lb)
Cate	03/29/24	05/16/24	Ounce (oz)
Silas	09/15/24	06/30/24	Liter (L)

- Table 2: dim_date (for reference)

dim_date =

VAR StartDate = DATE(2024, 1, 1)

VAR EndDate = DATE(2024, 12, 31)

RETURN

ADDCOLUMNS(

CALENDAR(StartDate, EndDate),

"Year", YEAR([Date]),

"Month", FORMAT([Date], "MMMM"),

"Month Number", MONTH([Date]))

* 2 tables above connected via Date = Date_Exam

I want to create 2 slicers: 1st "Date_type" (include Date_exam, Date_release), 2nd "Time_range" (get Date column in dim_date table)(dropdown value list)

So if I choose Data_type = "Date_exam" and time_range = "01/15/24", my expect Dile_fact result will display row has Date_exam = "01/15/24"

Could someone please help me how to implement it? As a newcomer to Power BI, I would greatly appreciate your assistance. Thank you!

Forum Discussion

Date Slicer

Between Date Slicer

Date Slicer

Date between slicer - Change order

Default Date for date slicer

Date Slicer not Responsive to Calculated Date Table