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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors