Forum Discussion
Stacked Column Chart Filtering Other Charts
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?
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. :smileyvery-happy:
6 Replies
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.
- 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.Hi mtmcd,
Could you please show me your chart and data fields so I could understand your situation correctly.
