March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Good evening.
I'm trying to calculate moving averages on geophysical data, a bunch of drillholes, where the first column is the hole name, the second is depth and third is the specific weight.
My x-axis is depth and y-axis is specific weight. The problem is that I have an absence of information, that is, I have data for shallow depths and for higher depths, with a hole in the middle. When plotting, Power BI “connects” the two ends with a line.
The objective is to plot the raw data and a line, representing the moving average, only in the portions that I have information.
Here is the current situationusing the following code:
And this tis the aim!
So...any help?
Please.
Att
Tiago
Hi @Anonymous ,
Or directly import the data into Power BI and use DAX for modeling, maybe you can give us a sample data.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi.
How can I do that?
Tiago
@Anonymous If you are referring to providing sample data, you can post a PBIX file to a file sharing service like OneDrive or Box and share a link. Or you can paste sample data as text using the table tool in the ribbon when posting.
I did this once: https://community.powerbi.com/t5/Quick-Measures-Gallery/Mind-the-Gap-Irregular-Time-Series/m-p/99179...
Not sure if there is a simple fix for this. Initial thought is to add a column (in DAX or M) that puts the data into dynamic groups/categories (e.g., breaking on where there are big gaps in x axis data). You could then use that column as a legend. They would start different color but you could change the colors to match I think.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
87 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |