Forum Discussion
Is it possible to use a single time dimension using 3 different dates in slicers?
Hello everyone !
I ask them, I have 3 dates in my fact table and they are all related to my date table.
In my report I have 3 date slicers and I need each one to correspond to the selected column.
Example:
1 . I have a date of birth and a slicer with a range that can be selected for all birthdays within that range.
2. Another is the Entry Date (it would be the second slicer).
3. And the last one is the departure date (third slicer).
Is it possible to do this having a single date dimension?
Thank you!
Regards!
Anonymous , As long as they are needed in formula and same date can work, yes you can. Join with same date dimension and use userelation in the formula
Refer to this blog how to do that
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos.
2 Replies
- amitchandak
Super User
Anonymous , As long as they are needed in formula and same date can work, yes you can. Join with same date dimension and use userelation in the formula
Refer to this blog how to do that
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
Appreciate your Kudos.Thanks amitchandak !