Forum Discussion

Spazia's avatar
Spazia
Frequent Visitor
6 years ago
Solved

Date hierarchy slicer, dynamic value

Hello,  I have in my table date from May and June.  In the future this table will expand with the years.    I've a Hierarchical date slicer in which I display the year and the month. When I chose...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Spazia 

    That because you are using built-in date hierarchy in the slicer, it likes you drag it into table visual too.

    So, you could custom create a year column, month column and day column, then drag them into slicer.

    Result:

     

    and here is sample pbix file, plase you it.

     

    Regards,

    Lin

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I fully agree with you on the misleading point. Did you find a solution? I am also struggling with this. I have for example a whole report page where I pretty much reporting the same stuff - let's say sales numbers for different groups of products.

 

I have one general slicer to select the product group as in most cases, it is pointless to compare figures across product groups and do not want to make pages for each new product groups. So now because of this weird (default?) slicer behavior, I get all dates in my date slicers regardless of wether the product group was introduced this year or last year. Is there an easy way to fix this by now?

 

Cheers, AAB

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey,

Unfortunately I didn't find any solution...

Sorry