Fitlering down data using a Line and Clustered Column Chart

[RevJoe]

Does anyone know how to filter down data on a second visual by clicking clicking on the line portion of a line and clustered column chart?  It looks as though the bar portion of the chart can be used to filter down data displayed in another visual. 

For example, I have a line and clustered column chart that displays current year payment data (by month) with the bars and prior year payment data (by month) with the line.  I would like to click on a bar for a specific month so that a second visual shows the current year payment data broken out by payment terms.  Then, if I click the line for a specific month, then second visual would show the prior year payment data broken out by payment terms. 

Would be a nice feature because the line and clustered column chart is a great option of the initial visual (as opposed to simply a clustered column chart). 

[v-shex-msft]

Hi @RevJoe,

Can you please share some detail information about this issue? It seems works on my side.

When I drill down one of years data to month level and click on one bar, other visuals will show the selected value.

Drill down 2015 dataDrill down 2016 data

Regards,

Xiaoxin Sheng

[RevJoe]

Thank you for the reply!!!

What I am hoping to accomplish is to be able to filter down other visuals when selecting the line portion of the Line and Clustered Column Chart.  I do not have any issues filtering down when selecting the a column, but I would hope to see similar filtering when selecting a value on the line portion of this visual also.  

Joe

[v-shex-msft]

Hi @RevJoe,

Current Line and Clustered Column Chart only support to filter with legend, it not support filter with axis(line). You can submit a idea to ideas forum.

BTW, line chart also not support filter with axis.

Regards,

Xiaoxin Sheng