---
title: "Walkthrough: Add New Custom Chart"
slug: "walkthrough-add-new-custom-chart"
updated: 2023-03-03T18:51:31Z
published: 2023-03-03T18:51:31Z
canonical: "help.lanteria.com/walkthrough-add-new-custom-chart"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.lanteria.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Walkthrough: Add New Custom Chart

In this walkthrough, we will show you how you can use an existing [Lanteria HR Power BI template](/v1/docs/power-bi-integration-template-overview) to change an existing dataset and build flexible visualization in the form of a chart. We will use the Release_AbsencesV2.pbix template, to which the LanteriaHR.Countries table will be added from the ESDB_* database to build a chart that shows company absence statistics by country.

*Note**Prior to using the Lanteria HR Power BI templates for building Power BI reports, ensure that the preliminary* [*setup*](/v1/docs/power-bi-integration-setup) *is performed both in Lanteria HR and on the Power BI side.* 

### To build a Company Absence Statistics by Country chart using the Absences template

1. In Power BI Desktop, open the required Lanteria HR Power BI template. In this case, it's Release_AbsencesV2.pbix.
2. Click Edit Queries > Data source settings.  
![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/img140.png)
3. In the Data source settings dialog window, click Change Source.  
![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/img142.png)
4. Specify the name of the SQL server and database that stores the Lanteria HR data for Power BI (it starts with ESDB_), and then click OK.
5. To finalize the change of the data source, click Apply Changes.
6. Right-click on the existing Company Absence Statistics chart, and then click Copy Visual.  
![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/img144.png)
7. Create a new page for the chart by clicking the ![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/PowerBIAdd(1).png) icon at the bottom of Power BI Desktop, and paste our existing chart to the new page (CTRL+V or right-click > Paste).  
![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/img146.png)
8. Click Get Data > SQL Server.  
![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/img148.png)
9. Specify the SQL Server and database, select the type Import, and then click OK.  
![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/img150.png)
10. To import new data, select a table or view from the list (in this case, we're selecting the LanteriaHR.Countries table), and then click Load.  
![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/img152.png)
11. In the left pane, click the Relationships ![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/PowerBIRelationships(1).png) icon, and ensure that the table relationships are correct.![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/img154.png)
12. After the table is loaded, use its data for building custom visualizations (in this example, we took Lanteria HR Countries.Title as Details for the existing chart).  
![](https://cdn.document360.io/c315c68d-2799-4fcc-9a39-084315b58f14/Images/Documentation/img156.png)