Slicer for chart legend

[spoony]

I have a table with 4 columns: Month, input, output, combined. Month is the x axis on the bar chart showing months/year data and the other columns are whole numbers data. Instead of plotting 3 charts, I need to plot a single bar chart and with a slicer elsewhere to select which of input, output or combined appear on the chart individually or together. How is this done?

[Anonymous]

Hi @spoony,

>> Instead of plotting 3 charts, I need to plot a single bar chart and with a slicer elsewhere to select which of input, output or combined appear on the chart individually or together.

You can write a measure with the slicer to show the display one of these value, but I don't think it support to show them together, value field only support value type.(if input the text string, it will auto convert to "count of xxx")

Measure sample:

SelectedItem= If(Hasonvalue(Table[Column],Values(Table[Column]),Blank())

Displayed=If([SelectedItem]="abc",Max(Table2[Input]),If([SelectedItem]="def",Max(Table2[output]),Max(Table2[combined]))

BTW, legend not support measure, calculated column not support to dynamic change result with slicer. So I think current it impossible to dynamic change the legend field.

Regards,
Xiaoxin Sheng

[tjd]

See the discussion at "Using slicer to choose which dimension to display".  I beleive that it is relevant to what you are trying to accomplish.

 

[spoony]

It seems this is not possible to do from the other posts. So next best thing is hierachy drill down. How would i create psuedo hierachy from my table between the columns?

[tjd]

My suggestion would be to use a clustered column chart with the following setup:

1. Shared Axis (3 items which become the "drilldown":
   1. Input
   2. Output
   3. Combined
2. Column Series: Month
3. Column Values: whatever common measure is that you've got monthly data on - sales, revenue, etc.