Connect the display of two different date slicers on a tab

[Anonymous]

Hello Everyone,

What I would like?

I want to be able to slice easily per date and make the different date slicers impact the display of the others.

For example, I have two date slicers:
1) With the date range as a "between" display
2) With "relative date" display to quickly select the last week or month (see below)
However, when I select "last 3 months", it doesn't directly impact the date slicer (1). I would like the date range to automatically correct according to my selection in slicer (2) and vice-versa.

What is my problem?

I have tried to create a slicer group but it doesn't work. Syncing the filters (which is used for cross-tabs filtering) doesn't do anything neither. Do you have any idea?

Thanks,

Mailys

[amitchandak]

@Anonymous , Relative date slicer always works with respect today to it will force the date relative to today. This will not work.

[Anonymous]

I will soon receive the data to complete the data from May to Today so this should be my problem.

Is there any way that a slicer affects the choices of another? (I can't connect with a relationship, the slicers are LookUp Tables with already numerous relationships with other tables)

Example 1:

I have dates from 05/01/2020 to today and two slicers "between" (or date range) and "Date Hierarchy" (allowing me to select some Years, Quarters and/or Months): if I select the Month of June in the Date Hierarchy Slicer, is there a way to make it affect the Between Slicer which will display a range 06/01/2020 to 06/30/2020.

Example 2:

I have this time a list of Sites and Customers: Each site deals with some of these customers, but not all of them. How can I make appear only the customers related to one selected site and vice-versa?

Thanks,

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

Do you mean something like this?

If you are not using "relative",it can be achieved,just modify the interactions between the slicers.

Here is the reference.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

2.Can you provide some sample date?For my understanding,using a slicer can simply achieve it if you have a table with the data of  Sites and Customers inside.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!