Does Slicer don't work on hierarchy date?

[kavitabehera15]

Can anyone confirm whether this is the correct behavior or a bug?

I am using a date slicer to apply a filter and table with a date hierarchy.

But the slicer is not working on the table view whereas the same works perfectly on the bar chart.

@hep @PowerBI @UserE  @krishb1414 @amitchandak @Ahmedx 

[Ashish_Mathur]

Hi,

In the Calendar Table, create seperate column for Year, Month, Day and drag these columns to the visual.

[v-binbinyu-msft · Accepted solution]

Hi @kavitabehera15 ,

If your table visual only has one hierarchy date field, the slicer really won't work at this point, you'll need to add another field to the table visual, and then the slicer will work.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.