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:DateClientProjectHoursBillableBillable RateBillable AmountTaskTypeNameEmployeedinsdag 1 januari 2019Data WiseCloud Architecture8No86688InternNon-billableKlaas WoutersWoensdag 6 februari 2019 AbInbevCustomer interaction PoC8Yes90720Billable Customer TimeBillableKlaas WoutersVrijdag 1 maart 2019Data WisePyspark8Yes86688InternNon-BillableAstrid LemmensVrijdag 1 maart 2019Data WisePyspark8Yes86688InternNon-BillableKlaas WoutersVrijdag 5 april 2019Ab InbevCustomer interaction PoC8Yes90720Billable customer timeBillableKlaas WoutersVrijdag 5 April 2019Data WisePyspark8Yes86688InternNon-BillableAstrid LemmensVrijdag 5 April 2019Airport CompanyPipeline8yes86688Billable customer timeBillableRandy cuppensMaandag 8 April 2019Data WisePyspark8Yes86688InternNon-BillableAstrid LemmensMaandag 8 April 2019Airport CompanyPipeline8yes86688Billable customer timeBillableRandy cuppensThanks in advance.

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

Not applicable

6 years ago

Solved

Empty value on Graph

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.

Need Help

Icey
6 years ago
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.
Icey
6 years ago
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.

Forum Discussion

Empty value on Graph

6 Replies

Related content

empty table values

Creating Cumulative Graphs

nextday empty value

Count vs displaying value in graph

Change Font of Column Header if values are empty