Professional KPI series 1 Part 2-The Area Chart

Shashanka Shekhar
Microsoft Power BI
Published in
5 min readFeb 16, 2024

--

Power BI is a platform that allows you to connect to various data sources, transform and model your data, and create interactive dashboards and reports. Power BI can help you gain insights from your data and communicate them effectively.

What is a KPI?

A KPI, or a key performance indicator, is a measurable target that shows how well an individual or a business is performing in terms of meeting their goals. KPIs can be financial, such as net profit or revenue, or nonfinancial, such as customer satisfaction or retention. KPIs help organizations track their progress, identify their strengths and weaknesses, and make informed decisions to improve their outcomes.

Building the KPI

We will be making this KPI:

The Professional KPI we will be making

Here we have YTD and YoY percentage calculations followed by an Area chart of current year sales.

About this part of the series

This is the part 2 of the series. In part 1, we built the indicator part of the KPI, use this link to check it out. In this part will be making the area chart.

Part 2-The Area Chart

In this part we will be making this Area Chart:

--

--

Shashanka Shekhar
Microsoft Power BI

Contributor for Microsoft Power BI. I like Data Analysis and Data Science. Also I enjoy sports, videogames and Japanese Anime in my free time.