Forum Discussion

kitcatnj's avatar
kitcatnj
Frequent Visitor
3 years ago
Solved

Trouble Duplicating Line Chart From Excel In Power BI

Hello. Relatively new here. I THOUGHT i understood how to create a chart. For some reason, no matter what combination I try, I can't seem to correctly re-create the line chart from Excel in Power BI....
Need Help
  • grantsamborn's avatar
    grantsamborn
    3 years ago

    Unpivotting your table in Power Query is the key step.

     

    Follow these steps:

    In Power Query
    - select Food column and unpivot other columns
    - fix up the period and convert it to a date

    Create and configure Date table.

    Line chart with:
    - x-axis: MMM-YY
    - y-axis: [Sales] measure
    - Legend: [Food] column

     

    pbix: https://1drv.ms/u/s!AnF6rI36HAVkhPIi3NykR9olljC9sw?e=n6zGcI

     

    Let me know if this helps.

grantsamborn's avatar
grantsamborn
Solution Sage
3 years ago

Unpivotting your table in Power Query is the key step.

 

Follow these steps:

In Power Query
- select Food column and unpivot other columns
- fix up the period and convert it to a date

Create and configure Date table.

Line chart with:
- x-axis: MMM-YY
- y-axis: [Sales] measure
- Legend: [Food] column

 

pbix: https://1drv.ms/u/s!AnF6rI36HAVkhPIi3NykR9olljC9sw?e=n6zGcI

 

Let me know if this helps.