Forum Discussion
Line Chart Sales Report / Axis Issue
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 ...
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/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
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/