Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
infantpowerbi
Helper II
Helper II

Change the trend line format in line chart

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
download.png
But my client request to see his line chart in below format

Expected OutputExpected Output

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

1 ACCEPTED SOLUTION
AnkitBI
Solution Sage
Solution Sage

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.

View solution in original post

4 REPLIES 4
AnkitBI
Solution Sage
Solution Sage

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.

Tq for your response,


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

download.png

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

Hello Ankit,

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.