need help on the line chart

[Anonymous]

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.

[mussaenda · Accepted solution]

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.

[parry2k]

@Anonymous better you unpivot your data in power query and then it should be straight forward. 

[Anonymous]

@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.

[Anonymous]

parry2k 

would it be able to show the value according these dates?