Forum Discussion
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. I do not see the options available in Power BI to do this quick, perhaps any tricks to do this?
Cheers,
Owen
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
4 Replies
- amitchandak
Super User
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
amitchandak - I see... do you recommend any slicer suitable for this case? sorry I am new to Power BI.
Hi owenkosnen ,
Here are the steps you can follow：
1. Create calculated column.
Year = YEAR('Table'[Date])QUARTER = "Qtr"&" "&QUARTER('Table'[Date])2. Take [Year] and [QUARTER] as slicers, respectively.
3. Result:
When you select Qtr1 of [QUARTER], it will display Qtr1 of 2019, Qtr1 of 2020, and Qtr1 of 2021.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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
