cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kowan Frequent Visitor
Frequent Visitor

Page level filter (date hierarchy slicer)

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.

question.jpg

 

Thank you.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Page level filter (date hierarchy slicer)

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.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Page level filter (date hierarchy slicer)

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 Frequent Visitor
Frequent Visitor

Re: Page level filter (date hierarchy slicer)

Thank you Maggie