cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abisaileon11 Regular Visitor
Regular Visitor

How to show a line graph by month

Hello there, 
I making a line graph to show sales of 2018 and 2019. I created a date table and I related this to dates in sales table.

I want the graph looks like this

Sin título.jpg

 

But when I put date in the axis it looks like this 

Sin títulol.jpg

 

I put a column in the date table of months, year and days but in the case of January it sums january of 2018 and 2019

 

s.jpg

 

Hope you can help me.

Thank you. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: How to show a line graph by month

Put the date hierarchy in instead of the date and choose a hierarchy of year and month and drill down into it to the month. With Categorical turned on.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Super User
Super User

Re: How to show a line graph by month

Try changing the x-axis setting from Continuous to Categorical in the Format pane.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

abisaileon11 Regular Visitor
Regular Visitor

Re: How to show a line graph by month

ssss.jpg

 

I tried what you say but it shows me every day of the calendar, and if I put months on the axis box I have the same problem in January that sums sales of january 2019 and 2018.

Highlighted
Super User
Super User

Re: How to show a line graph by month

Put the date hierarchy in instead of the date and choose a hierarchy of year and month and drill down into it to the month. With Categorical turned on.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 4,177 guests
Please welcome our newest community members: