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.
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.
The DAX work would depend on where the data stored and if the data is static (i.e., not changing over time) or dynamic (i.e., would be updated weekly/monthly/etc.).