Forum Discussion
Solved
Year extract from date
Hi,
Can any one please help me on below issue.
I have etracted Year field from date using below calculated column
- Year = YEAR('Web Analytics'[Date])
When I have taken Year column into slicer i am getting 2017 records two times. I have only 2017 year data in year column.
How to show 2017 one record in slicer.
Hi ,
You can change the view of the slicer as list , that will list down as as drop down at the top of your slicer.
Regards.
1 Reply
Hi ,
You can change the view of the slicer as list , that will list down as as drop down at the top of your slicer.
Regards.