Forum Discussion

gquaiotti's avatar
gquaiotti
Frequent Visitor
5 years ago
Solved

Page level date filter does not affect date hierarchy

I need help to understand the reason why a page level filter on a date filter does not affect visuals that are using the date hierarchy but if the visual uses the date field, it works fine.   This ...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi gquaiotti ,

     

    Based on my test, after putting one column into Value field, the "Matrix with date hierarchy" will be filtered correctly.

     

    And for the hierarchy created manually, not auto-generated, it can also be filtered correctly without value field.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

gquaiotti's avatar
gquaiotti
Frequent Visitor
5 years ago

Thanks for your reply.

 

I am already using the column from the Date Table on the filter. The date column on the fact table is hidden.