Forum Discussion
Question Regarding Report
how to convert date into year like 2015,2016
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.
2 Replies
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
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.
