Cross-filtering doesn't work

[donollla]

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!

[donollla]

@NickolajJessen 

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?

[NickolajJessen]

That's a bit of a wonky dataset. You should probably look into unpivoting your data and possibly dividing your data into multiple tables.

[donollla]

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!

[NickolajJessen]

Unpivoting can be done ine power query. If it's a Live connection you won't have acces to make any modifications in Power Query though, right?

If that's the case, i know of no way do the filtering, that you are requesting, sadly.

[donollla]

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?

[NickolajJessen]

As shown in the second screenshot by dragging the brand to the legend field and the count to the value field

[donollla]

@NickolajJessen fair point, here's a screenshot:

the chart has basically the same values as the cards above

[NickolajJessen]

Are these division made using measures or legends?

[donollla]

In the bar chart, they're added under X-axis:

[NickolajJessen]

Ye, that's not how filtering work. Filtering only works, if you select a piece of data. And by selecting a measure, you are actually not selection a piece of data.

[NickolajJessen]

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#M6071...