Cross-filtering for Long Format Data

This is the classic long-format cross-filter trap. Each chart already has its own Question filter, so when you click a bar, Power BI adds a Response filter to the underlying table. The other charts still carry their own Question filter, and the two together produce zero rows.

The cleanest fix is to pivot the data to wide format inside Power Query, not in Excel. Reference your survey table, select the Question column, then Transform > Pivot Column with Response as the Values column. Set Advanced Options to Don't Aggregate. You will end up with one row per User ID and one column per question.

Now each chart's X-axis is that question's column (Y stays Count of User ID), and you can drop the per-chart Question filter completely. Cross-filtering works as expected because clicking a bar filters the user rows, and the other charts redraw on the same user subset. Your source Excel file is untouched.

If this helps, please mark it as the solution and give a kudos.

Thanks,
Shai Karmani

Let's connect in LinkedIn