Forum Discussion
Show dates for week numbers
Hey All - This date slicer slider works perfect for this report, however is there any way to show exactly what the start and end dates are instead of the numbers? If I change field to any other date column in my date table I can't use the slider. End Users want to know the dates. All input welcome. Thx
Hi ctedesco3307,
How did the calendar table design? Did these include any date fields? If that is the case, you can use the date value on the slicer with the 'between' mode to achieve your requirement.
If not, I think you may need to create a calendar table with the week number field, then you can use year and week numbers as relationship keys to link to your fact tables records.
Regards,
Xiaoxin Sheng
3 Replies
Hi ctedesco3307,
How did the calendar table design? Did these include any date fields? If that is the case, you can use the date value on the slicer with the 'between' mode to achieve your requirement.
If not, I think you may need to create a calendar table with the week number field, then you can use year and week numbers as relationship keys to link to your fact tables records.
Regards,
Xiaoxin Sheng
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.
Hi Anonymous - dates worked! Thank you
