Forum Discussion
line graph to show multiple plots when using slicer
Hi Anonymous ,
I understand now. There is no easy way to accomplish this with a line chart. It will require a lot of work with DAX expressions. However, you can easily display the data in a line and cluster column chart. I have attached a screenshot of how I created a line and cluster column chart with your example report.
Hello Anonymous ,
If I understand your requirements properly, you shouldn't have to create a new measure for each product. Instead use the field 'amount' as the value field for the line chart and keep the status slicer.
I hope this helps.
Hi Expert
Placing the field Amount into the Value... Does not give me a line for total and for each individual product... i need to show three / four or evern lines on the graph at any given time..the total also has to have its own line...
Hi Anonymous ,
I understand now. There is no easy way to accomplish this with a line chart. It will require a lot of work with DAX expressions. However, you can easily display the data in a line and cluster column chart. I have attached a screenshot of how I created a line and cluster column chart with your example report.
Hi Expert
I can do the solution you have, whats the leg work using DAX to get the desired results.