Forum Discussion

prothinker's avatar
prothinker
Frequent Visitor
5 years ago
Solved

Unable to create line graph visual

Hi

I was able to create a Table but not line graph. Could you pls tell me how to get my Date into the Axis field? The pbix file can be found here.

 

I would like my visual to look like this.

Thanks

 

Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    I looked at your pbix.  First change your x axis to Date instead of using the date hierarchy.

    Then you can change the x axis to categorical.  Change the format of the Date column in the ribbon if needed with that column selected.

     

    Pat

     

6 Replies

    • prothinker's avatar
      prothinker
      Frequent Visitor
      5 years ago

      Hi

       

      Thanks for your reply. I don't have this option.

       

      • prothinker's avatar
        prothinker
        Frequent Visitor
        5 years ago

        Hi

         

        I managed to find the Axis when I changed the visual to Line Chart.

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    I looked at your pbix.  First change your x axis to Date instead of using the date hierarchy.

    Then you can change the x axis to categorical.  Change the format of the Date column in the ribbon if needed with that column selected.

     

    Pat

     

    • prothinker's avatar
      prothinker
      Frequent Visitor
      5 years ago

      Thanks Pat

       

      I managed to change the Date from Date Hierarchy to Date but my graph is a straight line like this.

      How do I get it to look like this without having to scroll?

      • prothinker's avatar
        prothinker
        Frequent Visitor
        5 years ago

        I realized that it is a straight line because it is shown as Count. How do I get it to show Value rather than Count?