Forum Discussion
need help on the line chart
hi all,
based on the file, is it possible to have a line chart that show the total sales for the different date period?
for example: chart of 3 lines to show the sale for each date period for product c which has 3 different period.
any hint or advice is grateful.
Hi Anonymous ,
If I am not mistaken, you have already done the unpivot thing on your previous post so you are now quite aware of how it is done.
Your thread here.
This post is also about unpivoting.
The pbix file is attached here for you to understand the steps applied in Power Query based on the data you provided.
5 Replies
- parry2k
Super User
Anonymous better you unpivot your data in power query and then it should be straight forward.
parry2k could you explain a little on it?
- parry2k
Anonymous on edit query, select date column, right click and then choose unpivot other columns. It will give you two column, Attribute and Value, rename those columns (if you want)
Now you will have 3 columns in table. To visualize, use date on x - axis and value column on values it will show sum of value for all 3 customers for each date.
- mussaenda
Community Champion
Hi Anonymous ,
If I am not mistaken, you have already done the unpivot thing on your previous post so you are now quite aware of how it is done.
Your thread here.
This post is also about unpivoting.
The pbix file is attached here for you to understand the steps applied in Power Query based on the data you provided.
