Forum Discussion
Two dependent date slicers
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.
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! 🙂