Forum Discussion
not using date slicer but instead allow user to enter from a date picker for start and end date
How to create a Start Date and an End Date without using a slicer from a single column from a Fact table?
I have a column called DIM_DATE[CALENDAR_DATE] which is linked to a fact table.
What I would like to do is to create a date range, but NOT using the inbuilt Power BI Date range slicer at all, and allow the user to pick a date for Start date and do the same for the enddate and 2 seperate fields. Then the values from the single date pickers will be used to Filter out the results.
Thanks
Hi,
This is possible to achive. Then you need two date tables.
This two tables cant have any relationships to the fact, just be stand alone.
Then you need slicers, one for each data table so the end user can pick from - and to date.
At last you need to create a measure on the fact table with the correct aggregation (sum, count or What you need), with a filter Where start date is >= the first date end user pick and end date <= the other.
Br
Marius
1 Reply
Hi,
This is possible to achive. Then you need two date tables.
This two tables cant have any relationships to the fact, just be stand alone.
Then you need slicers, one for each data table so the end user can pick from - and to date.
At last you need to create a measure on the fact table with the correct aggregation (sum, count or What you need), with a filter Where start date is >= the first date end user pick and end date <= the other.
Br
Marius