Forum Discussion
Choosing data for a trendline
I am trying to create a trendline visual (linechart object) for a customer in process industry where the user could choose a single product line's data (=daily values) stored in a table column, each row has one value.
In my case I can only fit one big linechart to my report page but there are several product lines and users want to change which product line is shown at a time.
The dates are in the next column and again each row has one date and in my case I would like to show the last 14 days. I can create a linechart and make it show this but what I don't know how to do is a slicer(?) which could show all available product lines which could then control my linechart object.
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
5 Replies
Hi 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=h8lpnvIn 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.
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
