Change the trend line format in line chart

[infantpowerbi]

Dear All,

I am infant to Power BI and I am implemenitng line Chart using data in excel,
In the line chart It is showing the lines of year in below format

But my client request to see his line chart in below format

Expected Output

Can any one please help in solving this issue by going through the below Power BI file
https://www.mediafire.com/folder/jn1hiwrqhm6gt/

[AnkitBI · Accepted solution]

Create a  new Calculated Column as and use it in Line Axis. You can sort visual asc/desc based on this column.

YYYY/QQ = COMBINEVALUES("/",Table2[Year],Table2[Quarter])

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

[infantpowerbi]

Tq for your response,

After using the below formula in new column I am getting tis result

[AnkitBI]

Why do you need Legend. When all your Year/QQ are being shown in Line Chart ?

[infantpowerbi]

Hello Ankit,

Tq for your kind information, I retroed and really I don't need legend.