Line and clustered column chart - Comparing MoM

MattAllington

The Issue I have with the Line and Clustered Column Chart is the following:

and I don't know if there's really a solution other than creating individual Measures for the LIne Values

The Column Series automatically slice the data into years however I wish they would do the the same for the Line Values!

(I do realize it says Column Series so it slices the Data only for the Column Values)

However I wish this actually acted more I guess like a Legend (slicing both Measures for the Columns and the Lines)

Hopefully this example will illustrate...

So here's my setup

Shared Axis - Month

Column Series - Year

Column Values - Volume

Line Values - Avg Price (represented by Green Line in picture)

PLUS a Year Slicer!

So by default you'll automatically get a column for each Year with only one Measure in the Column Series.

However if you do not write explicit Measures for the years selected

you'll get 1 line averaging each Month's price over all years selected - the one in green.

To get the individual lines you have to write separate Measures!

Hope this makes sense...

I hope they add a feature like this someday in the not too distant future :smileyhappy:

Thanks! :smileyhappy:

Any suggestions are welcomed:smileyhappy:

Anonymousor Anonymous or Vvelarde