Can't interact (filter by clicking) with a stacked bar column if I scroll

[Pynter]

Basically I have a stacked bar column and it works fine, but if I want to filter by one of the bars after scrolling (scrolling to the side because there are too many bars to show) then I can't interact with these bars that are scrolled to, only the ones that are shown on the start, any idea how to fix it?

[rajendraongole1 · Accepted solution]

Hi @Pynter -Can you check on large number of categories (bars) in the chart, Power BI might struggle with rendering and interactivity after scrolling. Consider reducing the number of categories by aggregating some of the data or using a slicer to limit the displayed bars.., also check the visual interaction is configured corrected.  check with some other alternative chart. 

Hope it helps. if any please share the snapshots of the visuals or upload pbix file with sample data.

[Anonymous · Accepted solution]

Hi, @Pynter 

You can check the visual interaction settings to make sure that they are configured correctly. Sometimes, the default settings may not allow post-scrolling interactions. You can refer to the following link:

Change how visuals interact in a report - Power BI | Microsoft Learn

If possible, reduce the number of bars displayed at once, as rajendraongole1 said. You can use filters or slicers to limit the data displayed, which may help keep it interactive.

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1 · Accepted solution]

Hi @Pynter -Can you check on large number of categories (bars) in the chart, Power BI might struggle with rendering and interactivity after scrolling. Consider reducing the number of categories by aggregating some of the data or using a slicer to limit the displayed bars.., also check the visual interaction is configured corrected.  check with some other alternative chart. 

Hope it helps. if any please share the snapshots of the visuals or upload pbix file with sample data.