Dates in the Oil & Gas industry data can be a little tricky.
Especially when aggregating data, such as production volumes, to a daily level, and trying to connect multiple tables with date columns.
Some tables, such as tank levels or production volumes, could be based on a Gauge Date (aka Report Date) since the data is measured, aggregated, reported or “gauged” on that date (today), but in essence it is yesterday’s data, or to be more accurate, it is the data for the 24 hour period that began yesterday at the contract hour (e.g. 6am) and ended today at that same time, or the Production Date.
Other tables could have actual dates, such as sales tickets, run tickets, operation logs, etc.
Most websites that offer Nutrition Facts and Food data lookup functionality seem to offer a top down, food driven search function. First you select or search for a food and they return the nutrition facts for your selection. I was looking for the opposite and I couldn’t find it. Thanks to Power BI, I was able to build one in minutes, here’s how I did it…
About a year ago (March 2020) We needed a line chart that can do the following:
Allow the viewer of the report to change the Y axis scale on the fly
Allow the X axis to be placed near the top of the chart
Have the ability to invert the Y axis*
When we started, we didn’t want to reinvent the wheel, so we searched first but couldn’t find a chart on the App Source marketplace that could do all of these thing I listed above*. So we started creating our first custom Power BI Chart Visual: CHARTURO
Welcome to the second post in our miniseries: “Are You Developing Power BI Reports the Right Way?” In the two-part series we are designing a sample Power BI report visualizing the weather on Mars and using some real world techniques.