Empty value on Graph

[Anonymous]

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:

EmployeeCount = CALCULATE(DISTINCTCOUNT(FactHarvest[NameEmployee]))

And here is some sample data from the Fact table if needed:

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.

[Icey · Accepted 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.

[amitchandak]

did you try filter Employee count >0

[Anonymous]

Hi @amitchandak just tried that, didn't seem to fix the problem tho.

[Icey · Accepted 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.

[Anonymous]

@Icey  this semi-helps the problem but still gives a confusing visual:

[Icey · Accepted solution]

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.

[Anonymous]

Thanks alot!