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

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
Super User

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

@Anonymous 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


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


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
Super User

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/
Anonymous
Not applicable

Hi,

That link takes me to a sign-in page.


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

Anonymous
Not applicable

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/
Anonymous
Not applicable

Hello @Ashish_Mathur ,


Thank you for your help

You are welcome.


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

@Anonymous 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


Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


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.

Anonymous
Not applicable

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
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.