Forum Discussion
Legend (by field parameter) not getting filtered by visual filter
Community Championit would probably be better then to build the filter into the measure you are using itself.
Although I do have to say its quite difficult to read all that data with so many legends, even 60 is a lot. is there a better way of doing this maybe?
what are you trying to demonstrate?
Agreed, 60 is a lot. It's the big companies that show up on the chart that get highlighted vs. the smaller companies.
My filter is a simple measure that produces a 1 or 0 base on the value on the x-axis, like this:
_Mutual Filter = IF(SUM(Table1[Value]) > 100, 1, 0)
Table1 consists of:
- Company ID
- Value
A Company table looks like:
- ID
- Name
- Is Parent
The filter seems to work fine for the chart, but not for the legend.
There is a one-to-many relationship between Company[ID] and Table1[Company ID].
If I put Company Name and _Mutual Filter in a table, I can see that all of the companies come in with a value of 1, which means that the filter isn't getting applied to the list of companies.
I'm trying to figure out how to change my measure to include filtering on the Company Name, but I'm not understanding the row vs. filter context. Is it possible?
I pulled up a table in Power BI with Company ID, Company Name, Value, and _Mutual_Filter. Comparing the list of Company names in the table to the legend, I can see that the _Mutual_Filter does indeed filter the legend, but it's 78 companies rather than 60 that I thought I was calculating the "value" for the filter. So the chart is actually working correctly, and there's something in my calculation of value.
- vanessafvg
okey dokes, do you need anymore assistance?