Page level filter (date hierarchy slicer)

[kowan]

Hi All,

I would like to ask you about one thing.

When I'm using page level filter on Date (example: Year (DAX) is greater than 2015 ) only slicer with dates / DAX Year is filtered (The one with Year from date hierarchy is not).

Could you please advise why? 

Below you can find the screen.

Thank you.

[v-juanli-msft · Accepted solution]

Hi @kowan 

As tested and searched, when i use a date hierarchy slicer as you did, it doesn't support to be filtered by  any filter including page level filter.

For this problem, a workaround is as your last trial-

create a DAX column [year], add this column to the slicer, then adding any page level filter will affact this slicer.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kowan]

Thank you Maggie