Creating line chart levels would me much easier if we could dynamic change their legend with a Slicer or Drill Down . Imagine the situation (which is my case): You want to make a cost evolution anal...
I have a chart where im showing sales by category, with a drill down to the item level. I currently have the chart showing sales by year, with the year in the legend. i would like to have a slicer that allows me to dynamically change the legend from year, to month to quarter. So i can see sales by category or item, by any date frequency
