Doubt regarding year to use as slicer

[Likhitha]

Hi All,

    Im having some data which is in the form (2010-data(table),2011 -data(table),2012-data(table)),i don't have any date related information in my table like year or month or date.I want to use Year slicer,How to do that??Is that possible??

[s_pasapuleti]

You can split the column with delimiter "-" and then you can filter on year column.

I think it should work.

If it doesn't meet your requirement let me know.

Thanks.

[Likhitha · Accepted solution]

thank you...i got the solution...i manually entered the year column for each table and appended all the tables..

---

@s_pasapuleti wrote:

You can split the column with delimiter "-" and then you can filter on year column.

I think it should work.

If it doesn't meet your requirement let me know.

Thanks.

---