Forum Discussion
Choosing data for a trendline
Hi jannek，
I have made a test with your data sample, you could follow the steps bleow to get your expected output.
1. Get data from Excel and Edit in Query Editor.
2. Select Date and click Unpivot other columns under Unpivot Colums in Transform, then you will get two columns Attribute and Value.
3. Close & Apply
4. click the More options besides Attribute and select New Group.
5. Group the Production Line AA , Target Prod line AA and Baseline Prod lineAA as a Group. Do the same option for Production Line BB and CC. Then you will get a group column.
6. Create a Slicer with the group colum and create the Line Chart with the six line .
Here is the out put.
For reference, the attachment is my test pbix file.
Best Regards，
Cherry
Resident RockstarHi jannek，
From your description, it seems that you want to create a line chart and a Slicer.
If it is convenient, could you share a dummy pbix file which can reproduce your scenario and your expected output, so that we can help further investigate on it?
You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best regards,
Cherry
Hi Cherry
And many thank for you to take a look at my problem.
Here are the links to .pbix file and excel file with sample data:
https://abb-my.sharepoint.com/:x:/p/janne_kaipainen_fi/ERj7Tzdvvi9HrD83jXq_MbcBAY9YBW9UkVJxynp6AHYpxQ?e=RRjZxW
https://abb-my.sharepoint.com/:u:/p/janne_kaipainen_fi/ETRKDQvjazRHlG6HJjoK-ekBauD1DHWOPhjRe-hPykzdng?e=h8lpnv
In the perfect solution the user should be able to choose a PRODUCTION LINE listed in a slicer and then the Trendline would show chosen PRODUCTION LINE *and* the TARGET and BASELINE relevant to this chosen production line.
- v-piga-msft
Hi jannek，
I have made a test with your data sample, you could follow the steps bleow to get your expected output.
1. Get data from Excel and Edit in Query Editor.
2. Select Date and click Unpivot other columns under Unpivot Colums in Transform, then you will get two columns Attribute and Value.
3. Close & Apply
4. click the More options besides Attribute and select New Group.
5. Group the Production Line AA , Target Prod line AA and Baseline Prod lineAA as a Group. Do the same option for Production Line BB and CC. Then you will get a group column.
6. Create a Slicer with the group colum and create the Line Chart with the six line .
Here is the out put.
For reference, the attachment is my test pbix file.
Best Regards，
Cherry
Hi Cherry
This is the perfect solution and exactly what I was looking for!
And now I also learned about the unpivot/pivot feature plus grouping attributes.
I hope also that someone else finds this solution useful.
Thank again you very much :)
BR.
janne k.
- v-piga-msft