Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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:

 

Made by me:

 

 

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.

  • 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. 

     

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

    Then you'll achieve the chart that you want.

     

    Hope that helps.

    Thank you

     

     

     

7 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion

    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. 

     

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

    Then you'll achieve the chart that you want.

     

    Hope that helps.

    Thank you

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

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

       

      Thanks Again ! 🙂

  • mussaenda's avatar
    mussaenda
    Community Champion

    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's avatar
      Anonymous
      Not applicable

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

      • mussaenda's avatar
        mussaenda
        Community Champion

        Hi Anonymous,

         

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

         

        Thank you 

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