Forum Discussion
Date hierarchy slicer, dynamic value
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
Community ChampionI think it will be uncorrect ideologically if Hierarchical date slicer will hide a part of Calendar
az38, I agree with you. But a slicer showing values for which there is no data behind is misleading for the end-users.
My objective is for 2020 I have the months of May and June. And in the end of the year I'll have all the months from May to December.
In January 2021, I'd like to be able to show only January for 2021.
If there is no possibility to make that, I could live with that and have in my slicer a concatenation between month & year.
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
Hey,
Unfortunately I didn't find any solution...
Sorry