Forum Discussion
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...
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
v-lili6-msft
Community Support
Community Supporthi 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