2 or more different kind of slicers on one page

[jaryszek]

Hello,

i have 2 different slicers coming from Dim_Date table:

Between slicer is built on Date and Dropdown slicer is build on date hierarchy. 
How to sync them? 

I tried to group them but it is changing also a slicer shape (they are either between slicers either drop down slicers).

How to make this working? What is the best approach? 
I am trying to give more possiblities to slice a dates like in azure portal...

Best,
Jacek

[v-sgandrathi]

Hi @jaryszek,

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used the sample data on my end and successfully implemented it.

I am also including .pbix file for your better understanding, please have a look into it:

Hope this will help you resolve your issue, if you need any further assistance, feel free to reach out.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[jaryszek]

thank you, we are close but it is not showing last 7 days or this Month values in Dim_Date table:

Best,
Jacek

[v-sgandrathi · Accepted solution]

Hi @jaryszek,

As you reviewed the shared .pbix file, we can see the month and last 7 days' data in our table.
I am attaching the file again for your reference. Please check it out, and I am also sharing a screenshot of the required output.

Hope my suggestion gives you good idea, if you have any more questions, please feel free to ask we are here to help you.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you.

[jaryszek]

Now it works, thanks!