cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kaimoon31
Frequent Visitor

Comparison this year Months vs last year Month

Hello,

 

I have the data base related to HR - Turnover data.

I would like to compare the turnover of each month of last year vs this year.

However the graph is not make sense when I try to compare it.

Compare 2018 vs 2019Compare 2018 vs 2019Only 2018Only 2018Only 2019Only 2019

 

I also created the calendar table by DAX Function.

Does anyone can help me on it?

 

Thanks 

3 ACCEPTED SOLUTIONS
Ashish_Mathur
Super User III
Super User III

Hi,

Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

@kaimoon31 did you used any measure to show the line graph or just straight column from the table, seems like there are missing values for some months and that's why you see those broken lines. it will make sense if you create a measure like something below, make sure add +0, it forces if there is no value, mkae it 0 and you will not see broken line.

 

Turnover = SUM( TableName[ColumnName] ) + 0





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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

10 REPLIES 10
Ashish_Mathur
Super User III
Super User III

Hi,

Share the link from where i can download your PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Hi,

That link takes me to a sign-in page.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hello,

 

I found the problem in here.

For the turnover value, I used group by month & year and have the value as below.

Capture.PNG

Then I display it by line chart. But, for some month, the value is null.

Therefore the line chart doesn't display the zero value

Capture.PNG

 

I tried some solution on Internet but I still not solve it.

Can you help me?

Thanks

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Hello @Ashish_Mathur ,


Thank you for your help

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@kaimoon31 did you used any measure to show the line graph or just straight column from the table, seems like there are missing values for some months and that's why you see those broken lines. it will make sense if you create a measure like something below, make sure add +0, it forces if there is no value, mkae it 0 and you will not see broken line.

 

Turnover = SUM( TableName[ColumnName] ) + 0





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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Hello @parry2k ,

 

I have not create any new measure.

Actually, in some few month, we didn't have any leaved employees.

Therefore, we will see 0 at this month.

 

I only created the new measure that is the new calendar by DAX function CALENDAR(..) and link it with my database.

 

Thanks

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors