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 analysis from a bunch of items from your company.
Then, you want to see it's average cost evolution by their family (ex: Wood, Wires, Copper Tubes, etc).
Next, I want to see the average of this, an average of categories (ex: Commodities, Metallics, Packaging, etc.).
And I could go on on 'upper' levels like checking the average cost evolution by Plant and then the corporative cost evolution.
To do this, I have to create a different charts for each analysis. The measure (or the value) is the same.
The only difference would be the the legend. Item at first, then Family, Category, Plant, and so on.
My idea was to use only one Line Chart.
What I first tried to do, was a Calculated column to be used as legend.
Using a Index table, this Calculated column would have a Switch to have it's value depending of the selected item from the Index table (with an Slicer for example).
The table would be something like this:
Plant | 0
Category | 1
Family | 2
Item | 3
If you got it so far, then I think you might imagine the situation I'm trying to create.
Just as additional, I have versions of data. So this column's values would be something like
"Version - (Categ/Family/Item) - Plant"
Hope it makes sense for others too. Please vote it :)
- Comments (1)
RE: (Dynamic Legend) Mix Calculated Column and Switch for Legend
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