Forum Discussion
Cross-filtering doesn't work
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!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.