Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Problem:
In Fact Table I have 5 different Dates like Imported, Collected , Exported , Arrived , FirstProcess and user wants a single select filter on this from where they will select Filter based on which datetype then on a date slicer they want to select From and To date range based on which the visual(matrix) should display the values.
Data Model
Star Schema Model with Dim(Import Mode) and Fact table(DirectQuery)
- DimDate table with single active 1 to many relation with FactTable.ImportedDate and 4 inactive 1 to many relation with FactTable.CollectedDate, FactTable.ExportedDate, FactTable.ArrivedDate, FactTable.FirstProcessDate.
I tried to create a table with Slicer with 2 columns - View and ID (This is sisplayed as Filter from where user can select the ViewDate type)
View ID
| Import | 1 |
| Collected | 2 |
| Exported | 3 |
| Arrived | 4 |
| FirstProcess | 5 |
Dax Measure
Thanks @amitchandak for te quick response, but my requirement is to filter based on one of the date selection. Lets say the user selects ImportedDate (column) rest all dates should be "All" and based on the date slicer the visual should show records with ImportedDate as selected. Some user selects CollectedDate(Column) then filter the Fact based on date selected against CollectedDate.
How do I write a Dax which will allow user to decide - date slicer is applied to date based ColumnA or ColumB or ColumnC ...
@AryaKrish , You have to use the common date table and you will inactive join which you can activate in measure using use relationship
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.