Forum Discussion
Solved
multiple columns in one chart
Hi, this might be an absolute n00b question, but I can't figure out how to do it. I have a table with several columns (four in this example). Each columns has a name and several hunders values. ...
SebastianAlmer , I think you need unpivot multiple times
amitchandak
Thanks for your support. The result should look like:
I've created a new table manualle with:
Table3 = {
("Col_A2",AVERAGE(Table1[Col_A1])),
("Col_B2",AVERAGE(Table1[Col_B2])),
("Col_C2",AVERAGE(Table1[Col_C2])),
("Col_D2",AVERAGE(Table1[Col_D2])),
("Col_E2",AVERAGE(Table1[Col_E2]))
}
Heres the PBIX:
https://almerprojekte-my.sharepoint.com/:u:/g/personal/sebastian_almer_de/EXugyWZgiVRPrjc92hA-q2YBhhYVkTa4MvHH-vlJ03f_6g?e=R4x5eH
But I have in the original file about 50 columns in several files. Would take me weeks to do this manually.
SebastianAlmer , I think you need unpivot multiple times
Nailed it.
I can't believe I didn't think of this myself.... 😂 🙈🙈