Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have a problem with empty values on my visualisations.
So I have this Dimension table which I downloaded from here.
And I have written some measurements in PowerBI, in my case an Distinct employee count in order to see the number of employees over the year. The problem now that when I put it on a grpah with months on the x-axis. I also get to see an empty part in my graph in my visualisation. See image.
Now I know I can filter the results to not show: "Isnot empty" but when I do this I get following visual which gives a false or confusing image.
Anyone that knows a solution for this? Because of this problem it now looks like we have a negative employee count for january which isn't true.
After that I also tried to start having the Y-axis start at 0 which semi-fixed the problem but still gives a confusing visual:
This is the measure used for Employeecount:
Date | Client | Project | Hours | Billable | Billable Rate | Billable Amount | Task | Type | NameEmployee |
dinsdag 1 januari 2019 | Data Wise | Cloud Architecture | 8 | No | 86 | 688 | Intern | Non-billable | Klaas Wouters |
Woensdag 6 februari 2019 | AbInbev | Customer interaction PoC | 8 | Yes | 90 | 720 | Billable Customer Time | Billable | Klaas Wouters |
Vrijdag 1 maart 2019 | Data Wise | Pyspark | 8 | Yes | 86 | 688 | Intern | Non-Billable | Astrid Lemmens |
Vrijdag 1 maart 2019 | Data Wise | Pyspark | 8 | Yes | 86 | 688 | Intern | Non-Billable | Klaas Wouters |
Vrijdag 5 april 2019 | Ab Inbev | Customer interaction PoC | 8 | Yes | 90 | 720 | Billable customer time | Billable | Klaas Wouters |
Vrijdag 5 April 2019 | Data Wise | Pyspark | 8 | Yes | 86 | 688 | Intern | Non-Billable | Astrid Lemmens |
Vrijdag 5 April 2019 | Airport Company | Pipeline | 8 | yes | 86 | 688 | Billable customer time | Billable | Randy cuppens |
Maandag 8 April 2019 | Data Wise | Pyspark | 8 | Yes | 86 | 688 | Intern | Non-Billable | Astrid Lemmens |
Maandag 8 April 2019 | Airport Company | Pipeline | 8 | yes | 86 | 688 | Billable customer time | Billable | Randy cuppens |
Thanks in advance.
Solved! Go to Solution.
Hi @Anonymous ,
Try to set the Start value of Y-axis (line) as 0.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Maybe I didn't explain clearly. The reference Y-axis of the line in the figure is on the right, not on the left. So, you need to change the start value of the right Y-axis to 0.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
did you try filter Employee count >0
Hi @Anonymous ,
Try to set the Start value of Y-axis (line) as 0.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Maybe I didn't explain clearly. The reference Y-axis of the line in the figure is on the right, not on the left. So, you need to change the start value of the right Y-axis to 0.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks alot!