Forum Discussion
Solved
How can I import historical values?
I want to have import the below matrix into Power BI in a way that I can create line chart and a slicer. Then, I can choose role from slicer and see the values through the dates.
However, when I import the data all dates are a different colum or if I transpose it all roles are different columns which I can`t group them and link them to other datasets.
| Role | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | Jan-23 |
| PC Manager 1 | 0.87 | 0.64 | 0.70 | 0.70 | 0.70 | 0.99 |
| Bid Manager 1 | 0.87 | 0.64 | 0.70 | 0.70 | 0.70 | 0.99 |
| Engineering Manager 1 | 0.87 | 0.64 | 0.70 | 0.70 | 0.70 | 0.99 |
| Commercial Manager 1 | 0.87 | 0.64 | 0.70 | 0.70 | 0.70 | 0.99 |
| Estimating Manager 1 | 0.87 | 0.64 | 0.70 | 0.70 | 0.70 | 0.99 |
| PC Engineer 1 | 0.87 | 0.64 | 0.70 | 0.70 | 0.70 | 0.99 |
| Bid Manager 1 | 0.00 | 0.00 | 2.33 | 1.86 | 0.47 | 1.05 |
| Construction Manager 1 | 0.00 | 0.00 | 1.16 | 2.09 | 1.40 | 1.92 |
| Commercial Manager 1 | 0.00 | 0.00 | 1.16 | 1.16 | 0.47 | 0.76 |
| Submission Manager 1 | 0.00 | 0.00 | 2.33 | 1.86 | 0.47 | 1.05 |
| Bid Writer 1 | 0.00 | 0.00 | 2.33 | 2.33 | 0.93 | 1.57 |
| Bid Coordinator 1 | 0.00 | 0.00 | 2.33 | 1.86 | 0.47 | 1.05 |
| Engineering Manager 1 | 0.00 | 0.00 | 1.16 | 1.16 | 0.47 | 0.76 |
Hi Fredi ,
You can try unpivotting all the month columns together to get them into "Attribute" and "Value" Columns and then you can easily use them in the line chart.
Hope this helps!
Please accept the solution if this answers your query.
Thanks!
Avantika
1 Reply
Avantika-ThakurSolution Supplier
Hi Fredi ,
You can try unpivotting all the month columns together to get them into "Attribute" and "Value" Columns and then you can easily use them in the line chart.
Hope this helps!
Please accept the solution if this answers your query.
Thanks!
Avantika