Stacked Column Chart Filtering Other Charts

[mtmcd]

I have a stacked column chart that shows the breakdown of SKU Counts per Product Model.  My problem is that when I click on a SKU within a column, the surrounding visuals are filtered by Product Model AND the highlighted SKU.  I want the surrounding visuals to be filtered only by the Product Model.  In addition to this, I can not select multiple SKUs within a stacked column chart.

Is this a limitation of Power BI, or am I missing something?

[tringuyenminh92]

Hi @mtmcd,

You could choose your current stack column chart -> Format tab will visible -> Choose Edit Interaction -> In surrounding charts, you will be able to choose the filter behavior of its chart  (Filter or Highlight) - in the top right of surrounding charts

if this is not what you mean, please let me know.

[mtmcd]

I have done that, but the issue is that surrounding visuals are sorted by the SKU. I want them to be sorted by the product model. If I could control - select each sku, then I would effectively be filtering by the product model, but that's not possible.

PS - just to clarify, I'm asking about stacked column charts. Your image above has simple column charts.

[tringuyenminh92]

Hi @mtmcd,

Could you please show me your chart and data fields so I could understand your situation correctly.

[mtmcd]

See image above. Product Models are A, B, C...  Sub model (SKU) counts are the stacked values.

When I click on one of the two SKUs, my surrounding charts are filtered by the SKU and therefore the corresponding product model. I simply want surrounding charts to be filtered by the product model and all associated SKUs. I don't want the chars to only show the sub model data. 

[tringuyenminh92 · Accepted solution]

Oh, I got your point now, @mtmcd, I have same question in last month. This is default behavior of chart. So you need add filter for these Product Model (could be treemap) and introduce your end-users to use it.

[mtmcd]

@tringuyenminh92 - OK, thanks for confirming the limitation!