Unable to create line graph visual

[prothinker]

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

[mahoneypat · Accepted solution]

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]

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]

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?

[darentengmfs]

Hi @prothinker 

Change your X Axis type from Continuous to Categorical.

[prothinker]

Hi

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

[prothinker]

Hi

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