Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |