Forum Discussion
line graph to show multiple plots when using slicer
Hi Experts I have cannot see the wood for the trees, here not sure if this can be done, see pbix file. 1. I have created a total measure which gives me the overall total value for the ...
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.).