Forum Discussion
Create line chart from Excel uploaded in SharePoint
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
1 Reply
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
