Forum Discussion

megavic's avatar
megavic
Advocate II
10 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi megavic,

Create a calendar table and import it into Power BI Desktop, then create relationship between the calendar table and your current table using Date Key. This way, you are able to drag Month from calendar table to Line Chart. You can check the example in the attached  PBIX file to get more details.

Thanks,
Lydia Zhang