how to convert date into year like 2015,2016
1 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.
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.
@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
