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

[owenkosnen]

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

[owenkosnen · Accepted solution]

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

[Anonymous]

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

[amitchandak]

@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]

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