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
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.
I also created the calendar table by DAX Function.
Does anyone can help me on it?
Thanks
Solved! Go to Solution.
Hi,
Share the link from where i can download your PBI file.
@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.
Hi,
You may download my PBI file from here.
Hope this helps.
Hi,
Share the link from where i can download your PBI file.
Hi,
That link takes me to a sign-in page.
Hello @Ashish_Mathur ,
Please find the other access link:
https://drive.google.com/file/d/1vhbDfKU6OFTHjagieTc0_jo_2pU_XJ9z/view?usp=sharing
Thanks
Hello,
I found the problem in here.
For the turnover value, I used group by month & year and have the value as below.
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
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.
You are welcome.
@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.
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
User | Count |
---|---|
160 | |
110 | |
96 | |
86 | |
75 |
User | Count |
---|---|
159 | |
136 | |
133 | |
81 | |
61 |