1 page, 4 different date filters for card visuals, can I drive all filters from one single slicer?

[RichHead1821]

It's sometimes difficult to put into words, and this may be an example...

I have a single page with 20 card visuals, the visuals are linked to 4 different date filters (assume 5 cards per visual) as the filtering is across 4 different dates in the model. At the moment to get all the results the user has to select each of the date filters and set to what I need (e.g. "Last  1  Calendar Month"), I'd like to be able to drive all of the filters from a single slicer, so that the user only has to select the filter once and it is applied to all 4 filters for all 20 cards.

Is this possible?

[amitchandak]

@RichHead1821 , if the four different filers are because of different table and date, You can use date table to control that.

But you can not initialize on slicer using another slicer

Date table can be joined with all tables and you can use a common date filter

for more than one date in same table, additional join you have one inactive join, that you can activate using userelationship

[RichHead1821]

Understood, thanks, I've not yet wrapped my head around how to activate a relationship, so have (cringe for the abuse) multiple date tables, as there are some tables with more than one date that I need to filter on.

[amitchandak · Accepted solution]

@RichHead1821 , You can have multiple date tables, when you need a filter on different months (say sales of march 21 and delivery of April 21 and both dates are in same table  )

But When I need to filer both on the same date, I can use inactive/active join with a date table

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[RichHead1821]

Thanks again, I shall have a good read.