topic Re: Scatter Graph and Day Lag Help ! in Custom Visuals Development Discussion

Scatter Graph and Day Lag Help !

Heni_p — Tue, 05 Nov 2024 16:44:30 GMT

Hello,

I am completely new to the forum and to using PowerBI and I am stuck on a project. I am trying to make a scatter graph on Power BI for the efficiency of Payments made after Employee's leave date as well as prior to their joining date. I've made a Leaving Day Lag code and a corresponding Hiring Day Lag however my scatter graphs are either blank or the layout just seems off. My code is at the top of one of the pictures. Any advice would be greatly appreciated :)))

Re: Scatter Graph and Day Lag Help !

lbendlin — Tue, 05 Nov 2024 18:07:39 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Scatter Graph and Day Lag Help !

Heni_p — Thu, 07 Nov 2024 13:50:08 GMT

https://1drv.ms/x/c/4026423328ee9db3/ESdqZRgrbaBGsbFE1CX1PboBvNN5WIGTt6lPSSNvHFTpsQ?e=BM80Oe

Hi,

Thank you for this guidance, hopefully this upload will work (this is all dummy data so there is nothing sensitive ). I also am attempting to make a line chart of active employees across the company's life time however my measure keeps doubling employee the number.

Re: Scatter Graph and Day Lag Help !

lbendlin — Thu, 07 Nov 2024 14:44:29 GMT

I cleaned up the source data a bit. Next step woud be to add a proper calendar table to your data model.