Two dependent date slicers

[Anonymous]

Hi Experts,

we have a requirement regarding slicers for date dimension.

Want to have two slicers for Period type, Period

Period type should have values like "Yearly", "Quarterly", "Monthly". Based on the period type selection, Period slicer should be populated. For example, if Period type "Yearly" is selected, then Period slicer should show values like 2019,20018, 2017. If "Monthly" is selected then Jan 2019, Dec 2018 etc. Similarly if Period type = "Quarterly" then Period should be Jan-Mar2019, Oct-Dec 2018 etc.

Please guide,  how can we acheive this type of functionality.

Thanks

[mwegener · Accepted solution]

Hi @Anonymous ,

a first idea, create bookmarks (buttons) with which you can show and hide corresponding slicers .

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[mwegener]

Hi @Anonymous ,

has your question been answered?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

Thanks @mwegener for your help.

I am trying to understand your solution. I have some doubts.

We already have a Date table coming from source, do you mean to create a new table, or unpivot some columns from our Date table. would appreciate if you can share any example.

Many thanks.

[mwegener · Accepted solution]

Hi @Anonymous ,

You may download my PBIX file from here.
Hope this helps.

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[JarroVGIT]

Well, this will take some work but it is possible. First you need to make a table like this:

THen, create a slicer based on DateType and another on Date:

This is however the easy part! If you change DateType, your selection options in slicer Date changes accordingly. But how does this change the visual you want to show? Here comes the hard part. You will need to create measures for everything you want to show, and you will need to include hard logic like this (IF selectedvalue(DateType) = Month, <calculation with Month filter>) etc. I don't have an example table and I really need to get sleeping but if you can't figure it out then give me a shout out and I'll have a look tomorrow evening.

Let me know if this helps! (Y)

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[mwegener · Accepted solution]

Hi @Anonymous ,

a first idea, create bookmarks (buttons) with which you can show and hide corresponding slicers .

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.