Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Dear All

Good Day

I am having the Same issue 

I am having a Data table As below of Weeks & values (in terms of Weekly Value & Accumalative Value),( I am Plotting the **bleep** Columns Column No.7,8,9

 

Mehanam3885_4-1606025953487.png

 

 

When i use a Line Graph it is shown like Below (Which is what i need) but remaining is to show the rest of the Months (Like Feb,April, Aug,ETC)

 

Mehanam3885_0-1606025197383.png

I Have Formated the weeks to show me Month & year only using this fromula 

Date (MY) = FORMAT([Date], "MMMYY") but the graph is shown like this (The Numbers has been Accumalated)
 
 
 

Capture.PNG

 

 

 Kindly I need your Support

 
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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.

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.