Line Chart Sales Report / Axis Issue

[Anonymous]

Hi everyone,

I have an excel line chart that I am trying to replicate in Power BI, but I cannot seem to do so. 

This is what the excel line graph looks like and is what I would like it to do in Power BI. 

Where the legend is the vehicle type and FYXX is the Axis. The issue I am having is the FYXX are all different columns in the sheet and of course I cannot have multiple X-Axis. 

My table looks something like this:

What would be the easiest way to go about fixing this?

Thank you for any and all suggestions!

[amitchandak · Accepted solution]

@Anonymous , For power bi, you have either transpose this table or unpivot it

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

[Fowmy · Accepted solution]

@Anonymous 

You first need to organize your data in Power Query. to have three columns MARKET TYPE, PERIOD and AMOUNT. You can do it using the Unpivot function refer to this videos: https://www.youtube.com/watch?v=Vff2kRBM95o&t=0s


Then it is better to create a calendar table and link: https://www.youtube.com/watch?v=BfFvNFTacNY

[amitchandak · Accepted solution]

@Anonymous , For power bi, you have either transpose this table or unpivot it

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/