Current Year Slicer

[Anonymous]

Hi Everyone,

I have a slicer that I created using DAX that shows all months and labels the current month as "Current Month" I would like to do the same thing with a year slicer that shows all year but labels this year as "Current Year". I've attached an image for reference.

However, I keep running into the issue that years are numbers, and "Current Year" is a text. 

Is it possible to create this slicer? How would I go about doing it?

Thanks!

[JIGAR]

@Anonymous 

You can create a custom column in your Power BI Editor. You can use this formula

NewYear = if([Year] = Date.Year(DateTime.LocalNow())) then "Current Year"
else
[Year]

Change the type of this NewYear column to text. 

You might have to handle the way these values are sorted on your slicer

Hope this helps !!

Thanks

[JIGAR · Accepted solution]

@Anonymous 

There you go.... Here is the link to pbix if you want to refer. 

https://drive.google.com/open?id=15Mtuw6TSIGdpYa51Mfd3TAeuhAQmh4JI

Hope this helps !!

Please mark it as accepted if the solution was appropriate.

Thanks

[Anonymous]

@JIGAR Thank you, very helpful!