Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Two dependent date slicers

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...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    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's avatar
    mwegener
    6 years ago

    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.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    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.