Forum Discussion
need help on the line chart
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 could you explain a little on it?
Super UserAnonymous 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.
parry2k
would it be able to show the value according these dates?