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 li...
Need Help
  • mussaenda's avatar
    mussaenda
    5 years ago

    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

     

     

     

mussaenda's avatar
mussaenda
Community Champion
5 years ago

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
5 years ago

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

 

Thanks Again ! 🙂