Combining 3 date slicers into one

Question

I have a PBI report that uses 3 date slicers to filter 3 different tables/visuals. How can I drive all three date ranges through one data slicer?&nbsp;Thanks

parry2k · Answer

Anonymous&nbsp;
&nbsp;
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
&nbsp;
Add Date DimensionImportance of Date DimensionMark date dimension as a date table - why and how?Time Intelligence Playlist
&nbsp;

anonymous · Answer

Parry2k, You video doesn't mention using the date dimension in a single slicer for 3 different tables. Will it work for that purpose?

parry2k · Answer

Anonymous&nbsp;yes it will.

anonymous · Answer

Parry2k, I'm able to create a hiearchy for the new date dimension but after turning off the auto date/time I can't create a hiearchy for the Recieved Date that was in an existing table.

parry2k · Answer

Anonymous&nbsp;you will use the hierarchy from the date dimension, you shouldn't be using in-built hierarchies. It is not a best practice, there are many videos/blogs that talks about why it is a bad idea. 🙂

Forum Discussion

Combining 3 date slicers into one

5 Replies

Related content

Between Date Slicer

Date Slicer

Tables combine

Default Date for date slicer

Date between slicer - Change order