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
Anonymous
Not applicable

Line chart

Dear Experts,

I am trying to replicate a line chart created by expert but unable to create in same design as it is.

 

Expected:

 

bhuprakash_0-1628689479352.png

Made by me:

 

bhuprakash_1-1628689520312.png

 

If you see my line chart , the line is showing straight and not looking good but if you see chart created by expert is looking cool. 

Please help me to create that.

 

Thanks a lot.

1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

Hi @Anonymous ,

 

Now I see where you are having the issue.

 

On the attached pbix you sent, I tested also the graph.

On your axis, right click the date and choose Date Hierarchy. 

1.png

 

On your graph, click this drill down. Remove the Quarter on your axis then drill down again.

2.pngThen you'll achieve the chart that you want.

 

Hope that helps.

Thank you

 

 

 

View solution in original post

7 REPLIES 7
mussaenda
Super User
Super User

Hi @Anonymous ,

 

Now I see where you are having the issue.

 

On the attached pbix you sent, I tested also the graph.

On your axis, right click the date and choose Date Hierarchy. 

1.png

 

On your graph, click this drill down. Remove the Quarter on your axis then drill down again.

2.pngThen you'll achieve the chart that you want.

 

Hope that helps.

Thank you

 

 

 

Anonymous
Not applicable

Dear @mussaenda , Thanks a lot for guidence. It worked after clicking on below drill down button.

bhuprakash_0-1628747090193.png

 

Thanks Again ! 🙂

Tahreem24
Super User
Super User

@Anonymous Your old chart has some more data points (numeric values) as compare to your recently created one.

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
mussaenda
Super User
Super User

Hi @Anonymous ,

 

Line graphs behave based on your data.

Ar you having the same set of data?

Using the same fields?

 

You did not provide any sample data.

We cannot guess why you chart is like that and the other looks cool.

Thank you.

Anonymous
Not applicable

I want to share pbix file with you but how to share. Attechment option not showing

Hi @Anonymous,

 

you can use file.io to attach the file and paste the link here.

 

Thank you 

Anonymous
Not applicable

Please download pbix from below link and check Page1

https://file.io/IHbs8a4s7oiv

 

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.