Posts

Posted on

Linear and Log in Power BI with Charturo Custom Visual

A while back on the blog we did a series that touched on changing between linear and log scales on the fly in Power BI. In this post, we’re going to see how using the Charturo custom visual from the Power BI Appsource simplifies the process of adding this functionality to Power BI Reports and the functional benefits of using Charturo over the standard Line Chart.

Charturo is an interactive line chart Mi4 has developed that allows the end users to switch between log and linear axes directly on the chart surface. It also allows inverting the Y axis, but we will spend most of this post talking about the Linear & Log functionality. Continue reading “Linear and Log in Power BI with Charturo Custom Visual”

Posted on

We ❤ Power BI so much we created a custom visual

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

Continue reading “We ❤ Power BI so much we created a custom visual”
Posted on

Power BI Small Multiples Preview Feature

A new Small Multiples visualization feature has been released for public preview in Power BI. I was thrilled to see this first announced on the roadmap and am looking forward to putting it through its paces now that it is out in preview.

“Small Multiples” use multiple similar views to show different partitions of a dataset. Small multiples are sometimes called trellis or grid charts and until now, you have had to use custom visuals or some SVG tricks to get the functionality in Power BI. Continue reading “Power BI Small Multiples Preview Feature”

Posted on

Productioneer Production Review Dashboard Update

We are happy to announce that in December 2020 Mi4 released an update to the Production Review Dashboard with new features and functionality. This dashboard is available to all Productioneer customers and allows oil and gas organizations to efficiently aggregate and analyze oil and gas production across a diverse collection of assets quickly and efficiently in one report. 

The Production Review Dashboard offers oil and gas companies a modern dashboarding tool without procuring any software licenses or building it in house.

Continue reading “Productioneer Production Review Dashboard Update”

Posted on

Azure Data Factory Date Parameters with Timezone Sensitive Default or Adhoc Values

Date and time values have been the bane of programmers’ existence since Pandora opened a box several millennia back……at least it feels that long. I wanted to share with you how we implemented flexible date parameters for an Azure Data Factory pipeline in a recent project.

Names, places, industries, widgets and other identifying information have been changed for entertainment purposes. Continue reading “Azure Data Factory Date Parameters with Timezone Sensitive Default or Adhoc Values”

Posted on

Use Power BI to Monitor Your Oil Storage Capacity with DAX Moving Averages Excluding Zeros

Productioneer has an extensive paginated report library for our customers to utilize. We have everything from simple data exports to paginated reports that highlight variances and trends.

One of the reports we have had in our library for quite a while, is the Tank Stock report. The user selects a day and the report returns the tank stock and tank production for each tank in the organization for the selected day. It aggregates the stock and production at the tank, battery, field, and organization level and provides the tank strappings (feet and inches) for each tank.  It is a standard and widely used report and I know it has not had any significant changes requested to it for at least 3 years.

Suddenly, without any warning, drastic changes in the market caused everyone to take a closer look at their storage capacity. We were receiving requests from multiple clients to add more analytics to the Tank Stock report. Continue reading “Use Power BI to Monitor Your Oil Storage Capacity with DAX Moving Averages Excluding Zeros”

Posted on

Jumpstart Enverus Drillinginfo Direct Access API Integrations

Disclaimer: Mi4 is not affiliated with Enverus. Mi4 does not endorse or recommend any particular data subscription service.

Mi4 has helped many of our clients integrate data from data subscription services into their own projects and data initiatives. One of the many subscription services we have implemented solutions around is Enverus Drillinginfo’s Direct Access API.  The Direct Access API allows Enverus customers with DI Plus subscriptions to access Enverus’ extensive collection of public data and bring it in-house.

TL/DR: Check out our C# Classes and SQL scripts for the Enverus Drillinginfo Direct Access API on our GitHub.

Continue reading “Jumpstart Enverus Drillinginfo Direct Access API Integrations”

Posted on

Power BI Line Chart with interactive log & linear scales

As an end-user of a Power BI report, a chart that looked great at first might look not so great once you start applying filters or using slicers. Very large values in the data might throw off the scales and now your line chart might be suddenly all squeezed at the top or the bottom. Does any of the above sound familiar?

EDIT: There is a newer version of this custom visual chart, which is now called CHARTURO and is published to the Power BI AppSource Marketplace, you can read about it here and get it from the Marketplace here

Usually it’s the report designer who has all the power, this article is about giving more power to Power BI end users…

End users’ ability to change the scale, appearance or formatting of that chart is limited. That’s why I started creating the Mi4 Line Chart Power BI custom visual that lets you switch scales on the fly, and eventually have more overall control of the visual without having to edit the report.

Continue reading “Power BI Line Chart with interactive log & linear scales”
Privacy Policy Made with ❤ in Texas.