Display year only in slicer

[JorgeAbiad]

Hello PBI Experts,

I am using a slicer in my report and I just want to display the year. However, it shows the whole date.

If I click Date Hierarchy, the control becomes a list or dropdown.

What is the workaround to remove the day and month part in the slicer control.

Thank you very much!

Regards,

JorgeAbiad

[Fowmy · Accepted solution]

@JorgeAbiad 

You need to have a separate column in your table to use on a slicer. Go to your table create a column as follows and assign it to a slicer.

Year = Year(Bonus_2019_Sheet[Fiscal year])

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak · Accepted solution]

@JorgeAbiad , Create a fiscal year with help from STARTOFYEAR or ENDOFYEAR

End Year = ENDOFYEAR([Date], "3/31") // if year end on 3 /31

Start Year = STARTOFYEAR ([Date], "3/31") // if year end on 3 /31

Based on one of these you can get a year

FY Year = Year([Start Year])

And use this FY as Slicer with between option.

You can also refer my blog: Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

[JorgeAbiad]

Hi @amitchandak ,

Thank you for the solution. It worked,

Regards,

JorgeAbiad

[Fowmy · Accepted solution]

@JorgeAbiad 

You need to have a separate column in your table to use on a slicer. Go to your table create a column as follows and assign it to a slicer.

Year = Year(Bonus_2019_Sheet[Fiscal year])

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn