Create line chart from Excel uploaded in SharePoint

[marial16]

Hallo,

I have uploaded an excel file on a SharePoint Document Library.

In the BI Desktop i bring all sheets of that excel file.

I want to create a Line chart (or KPI) based on rows from 2 different sheets.

Example of tables : Table1 (there are more Rows in every table but i want to create the charts for LW row values)

	Value1	Value2	Value3
LW	0,898	0,696	0,793

Table 2

	Value1	Value2	Value3
LW	0,35	0,21	0,30

The chart must look like this:

Any help would be appreciated

[amitchandak]

@marial16 , Add the sheet or  table name to both the table,

and Merge them

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

and unpivot the columns value 1, value 2 and value

https://radacad.com/pivot-and-unpivot-with-power-bi

Plot the attribute on axis , table name on legend and value on value