Hello everyone,
I'm using my Calendar table as a filter slicer.
Is it possible to make slicer look like this :
Instead of this :
I need to show distinct (YYYY-MMM) values on a filter slicer. Date Hierarchy isn't working in this case.
Thank you for your answers.
Solved! Go to Solution.
In the DateDim Table create a Field with YYYY-MM Then you can get the required view
Proud to be a Super User!
In the DateDim Table create a Field with YYYY-MM Then you can get the required view
Proud to be a Super User!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
75 | |
65 | |
51 | |
51 |
User | Count |
---|---|
184 | |
104 | |
82 | |
79 | |
78 |