Power BI - KPI Visual



KPI (Key Performance Indicator) is the best visual to determine the performance of the employees towards their defined target. It facilitates meaningful insights and permits companies to identify their strong and weak areas. Performance metrics must be defined and tracked through the KPI visual. For example, user reviews and customer feedback can be tracked, and crucial decisions are taken accordingly for further enhancements.

How to Develop KPI Visual in Power BI?

Step 1 − You can import the "D:\sales executive.xlsx" into the BI desktop and select the KPI visual from the "Visualizations". The default KPI visual is inserted into the Report canvas as it contains no fields. The three main sections of the KPI visual are "Value", "Trend Axis" and "Target".

KPI Visual in Power BI

Step 2 − You can place the "Current year target achieved" field into the "Value" and add the "Year" field into the "Trend axis". After that, add the "Previous year target achieved" field into the "Target".

KPI Visual in Power BI 1

As you can notice in the screenshot, the center value "450000" is considered an indicator that represents the last field value of the "Current year Target achieved".

Step 3 − You can observe the individual goals of the specific name through the "Drill through" section. Also, place the "Name" into the "Drill through" and choose "Used as a category" under "Allow drill through when" where all employees' names are listed sequentially.

KPI Visual in Power BI 2

You may click on the "Diana" that populates the measure performance of her on the canvas.

KPI Visual in Power BI 3

How to Format a KPI Visual?

You can click on the "Format visual" to customize the KPI visual. Various options like "Callout Value", "Icons", "Trend axis", "Target label", and "Date" are presented inside the Visual.

Format a KPI Visual

You may expand the "Callout value" change the Font style to "Calibri" and increase the font size to 45. Here, you may notice in the screenshot, that the performance measure which is "450000" styling has been modified. You may also alter the Horizontal Alignment and Vertical alignment of it.

Format a KPI Visual 1

You can turn on the "Icon" button and expand the Icon title to increase set its size to 22 pt.

Format a KPI Visual 2

The trend axis is the period that you added to the dataset. You can click on the "Trend axis", turn on its toggle button and select "High is good" under the "Direction". You can apply conditional formatting for "Good color", "Neutral Color" and "Bad Color".

Format a KPI Visual 3

You can turn on the Target label button and modify its formatting. You may expand the Values tile, alter the font style to "Symbol", increase the font size to "20" and choose the desired color from the drop-down list. Enter the "Target" under "Label" subpart.

Format a KPI Visual 4

As you can notice in the screenshot, the Target label styling has been modified.

You may also turn on the "Distance to goal" button and select the "Value" from the given list under the "Style" section. Choose the "Segoe UI" and set its size to 20 and choose the desired color from the given list of theme colors.

Format a KPI Visual 5

Therefore, the Distance to goal value is shown in numeric form instead of percentage and its default color is changed to the blue color.

You can click on the "Date" tile to view the period on the visual.

Format a KPI Visual 6

Now, you can click on the "General" tab for basic formatting of the KPI visual. Multiple options like Properties, Titles, Effects, Header icons, and Alt text are presented.

Format a KPI Visual 7

Properties

You can expand the "Properties" tile which consists of Size, Position, Padding, and Advanced options.

Format a KPI Visual 8

Moreover, you can click on "Size" where you can adjust the Height and Width of the report canvas. Here, you can set the height to 682 and the width to 1000.

Format a KPI Visual 9

Title

The next section "Title" comprises of the "Title", "Subtitle", "Divider", and "Spacing" subparts.

You may expand the "Title" to alter its default title name. Enter the new title "KPI visuals" under the Text section and change the heading to Heading 5, alter the font style to Corbel, increase the font size to 27, alter the Text color to "#893395", and select the "Center" alignment.

Format a KPI Visual 10

Lets change the background of the KPI visuals. You can expand the "Effects" and then click on the "Background" tile and then select the "#e8d166" color from the given list of the theme colors.

Format a KPI Visual 11

Similarly, you can also customize the subtitle and change its text styling and horizontal alignment after clicking on the Subtitle button.

Header Icons

You may alter the formatting of the Header icon which is at the bottom right side of the designated visual. Click on the "Header icon" toggle button and select the desired color for the "Background", "Border" and "Icon" subparts.

Format a KPI Visual 12

Therefore, the Header icon styling has been altered.

Advertisements