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.
When you flip to different visuals, you will see different value/filter/legend options. I suspect if you just click the line graph visual... you will see what you need?
Hi scottsen, thanks for your reply.
When I click the line graph visual I can't see how I can use each period balance field to appear as an entry on the x-axis.
Any help appreciated
Andy
