Forum Discussion
Solved
Line chart using a table that has multiple fields for x axis
Hi - new Power BI adopter here! I have a table that I'd like a simple line graph for. The issue I have is that the values for the x axis are in individual fields in the table, e.g. PeriodBalance1, P...
Ya, the "shape" of your data is not helping you. In the query update window thingy (power query) -- check out the UNPIVOT feature, that would change your life.
Ya, the "shape" of your data is not helping you. In the query update window thingy (power query) -- check out the UNPIVOT feature, that would change your life.
Oh that is sooooo good :smileysurprised:
That completely reshapes the query table data and is so simple but powerful!
Thank you very much for the suggestion, this is working perfectly.
Much appreciated - kudos and accepted answer :smileyhappy: