Forum Discussion
help with line chart and filter
hi all,
i got 2 issues in my chart, hope you can advice.
1) in the line chart, how do i get it to show something like this?
2) for the second chart, how do i filter by suppliers?
Thank you very much.
Hi Anonymous ,
What about this?
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
14 Replies
Tahreem24Super User
Anonymous ,
For your first issue, Use Line chart from Visualization pane. And drop the following in property option as below:
Axis --> Month
Legend --> Year
Values --> Numberic field
What I understood from your second question is to filter supplier in that chart so please take slicer and put supplier column in that slicer.
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
Thanks, I got the first one done.
As for my the second question, my data source only have the value and date.
the orginal source came from a server. how do i add a column with Supplier B in my data?- Tahreem24
Anonymous ,
I am not exactly geetting what are you saying, I apologise for that. But You wanted to create new column in your Supplier B table? is that so ?
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
- Tahreem24
Anonymous ,
For your reference please see the attached snap shot.
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!