Forum Discussion

owenkosnen's avatar
owenkosnen
Frequent Visitor
4 years ago
Solved

Date Slicer - Single Selection - How to exclude higher date hierarchy from the single selection?

Hi,   Just wonder if it is possible to exclude selection of "Year" from the single selection to avoid aggregation in Date Slicer? All I want to achieve is only to let users select quarterly data. ...
Need Help
Show and Tell
Tips and Tricks
  • owenkosnen's avatar
    owenkosnen
    4 years ago

    Hi Liu Yang,


    Thanks for your suggestion!
    Although this is not exactly what I wanted it to be (since it will involve two slicers) but I guess it is close enough and good as workaround.

    Thanks again!
    Owen

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

owenkosnen , even if you click on QTR, it will check the year. this is the behavior of a hierarchal slicer. You can use different slicers if needed

owenkosnen's avatar
owenkosnen
Frequent Visitor
4 years ago

amitchandak - I see... do you recommend any slicer suitable for this case? sorry I am new to Power BI.