Forum Discussion
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....
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 dateCreate and configure Date table.
Line chart with:
- x-axis: MMM-YY
- y-axis: [Sales] measure
- Legend: [Food] columnpbix: https://1drv.ms/u/s!AnF6rI36HAVkhPIi3NykR9olljC9sw?e=n6zGcI
Let me know if this helps.
