How to alter the axis into Year only

[GAPER]

I want the xaxis to be showing year only (not aggregrating yearly but just showing the year but not the exact dates)

I wanna alter the X-axis like the below

How can i do that? Thanks

[Idrissshatila]

Hello @GAPER ,

create a year column based on this date as following:

year = year('TableName' [Date])

then use this column in x-axis

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Uzi2019]

Hi @GAPER 
Please select the continous option under X axis

If my post helps then give kudos and accept my solution!
Thanks.

[GAPER]

I don't even have this option....Thanks

[ShinyFelicita]

Hi,

You can add columns from the year(add date, month, day and quarter) so you can able to filter based on the reqiurement.

Regards,

Shiny

[GAPER]

No... i just mean i don't want it to show the whole date. no even to filter anything.

I just need it to show marks of 2021, 2022, 2023...

[Uzi2019]

Hi @GAPER 

Select your date arrow > date hierrachy
 

You will get this option of year> qtr> month >date

Then cancel qtr, month, date 

If my post helps you give kudos and accept as a solution!
Thanks

[Uzi2019]

Hi @GAPER 

I have also taken scatter chart. I can see the option of date hierarchy.

[ShinyFelicita]

Okay. Then have year alone for your visual without days and month.(Which you have mentioned in the image)

[GAPER]

where is it though?

[ShinyFelicita]

Cant get you, can you share your data for this visual alone?

[ShinyFelicita]

I mean the data format for that visual..

[GAPER]

the X axis doesn't have any options to alter it. 

[ShinyFelicita]

Im asking to check your data for the year, if it is year, day and month as a single one or in a separate column one.