Implementation Of Custom High Chart Component Into Power BI

About the Customer

Industry: Oil & Gas

The client is from the Sales & Marketing department of the world’s leading oil & gas company. This department leverages multiple sales & marketing dashboards to gauge current sales, forecasts, and comparisons between different parameters. Based on these dashboards, they can get a detailed insight into future trends. The technology being used is Microsoft Power BI.

Power_BI_Custom_High_Chart_Implementation

Key Challenges

Power BI is a modern-day technology with almost all major functionalities embedded within. But there is a component needed for dashboards, not present in Power BI.

The needed component is supposed to portray the lower and higher range of area, with the current and forecast figures lying in between.

The team searched hard in the marketplace to get this component in Power BI but could not manage. They even tried to customize some chart options, search for paid options but could not find a matching solution.

Our Solution

Looking at the challenges of the client, SPEC INDIA helped the customer by offering them two solutions, with Power BI as the main technology, to showcase a variety of dashboards:

Custom Built Power BI Chart

A chart with requisite details and format can be built with certain .js libraries available in the market like D3.js. It would be a customized option with complete control but the efforts to build this component and its integration with Power BI would be quite high.

High Charts

The provision of using the High Charts component is available in the high chart library. The license must be purchased and there is integration effort involved to plot dimensions automatically and map with the high chart values. The main advantage of this option is the availability of advanced charts, which makes the integration of high charts with Power BI much easier and effortless as compared to a customized chart option.

SPEC INDIA offered both these solutions to the client and the client chose to go ahead with the high chart integration with Power BI.

Following Are The Key Features Of This Solution:

Element custom chart component effort
Elegant/customizable look as compared to other options
Offers more chart options in Power BI, to be included, if needed

Our team integrated the high chart component into Power BI so that it could be used for any number of dashboards as an individual component, not restricting it to a single-use component.

Our team integrated the component with PBVIZ, npm, and modified the visual.ts to adapt to the changes owing to the high chart library.

Showcasing these dashboards with the new component in the Power BI unit offered a lot of satisfaction to the client since it showed what they needed.