Question Regarding Report

[Satoshi]

how to convert date into year like 2015,2016

[Anonymous · Accepted solution]

Hi  @Satoshi ,

You can click on the Date hierarchy of the column [Date] – select Year.

This way the slicer will only display The Year.

If you need pbix, please click here.

Question Regarding Report.pbix

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Satoshi , You have to create a new column

FY = year([Date]) & "," & year([Date]) +1

Or

new date = format([Date], "dd mmmm yyyy" ) & "," & year([Date]) +1