Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
105 | |
101 | |
81 | |
79 | |
67 |
User | Count |
---|---|
122 | |
110 | |
94 | |
82 | |
77 |