Forum Discussion
Cross-filtering doesn't work
Hi,
I have a report page with 4 tables, 5 cards, and a bar chart. They are all based on one table only.
When I click on tables it filters the bar chart and the cards as expected. However, when I click on the bars on my chart nothing happens. Does anyone know why?
I'm a beginner so hopefully you can forgive me if it's something totally basic I'm missing.
Thanks!
11 Replies
This is very little information to go from. What does you data look like? What is on the X-axis of your bar chart?
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150NickolajJessen fair point, here's a screenshot:
the chart has basically the same values as the cards above
Are these division made using measures or legends?
In the bar chart, they're added under X-axis:
Thank you NickolajJessen . Could you please elaborate? I'm not sure I understand. How should I set it up so I can filter all other visuals by Brands?
As shown in the second screenshot by dragging the brand to the legend field and the count to the value field
Makes sense but that won't work in my case. As you can see I don't have a table listing brands in one column and values in the other. In my table I have 5 columns for 5 brands. If a brand a row is relevant for, say, Brand A, Brand A column contains an X:
Do you have any suggestions how can I get my page to be filtered by Brands with such setup?
That's a bit of a wonky dataset. You should probably look into unpivoting your data and possibly dividing your data into multiple tables.
Unfortunately there is nothing I can do about the data source. It's a live connection to the clients data and I cannot modify the data set on the source side. Is there anything I can do on the Power query/Power BI side to make this work? Filtering the visualisations by Brands does not seem like a complicated thing but I'm stuck.
Appreciate your help!
