cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mahitham Regular Visitor
Regular Visitor

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.

Year.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
praiselyabraham Regular Visitor
Regular Visitor

Re: Year extract from date

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.

Capture.PNG

 

Regards.

1 REPLY 1
Highlighted
praiselyabraham Regular Visitor
Regular Visitor

Re: Year extract from date

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.

Capture.PNG

 

Regards.