Forum Discussion
Filter a table visualisation using a bar chart
Alright then, I believe what you would need to do is to put the error field on the "legend" well of the bar chart, and select the error field you want on the legend:
Versus just selcting the column:
Othen than this I got nothing, would be interested to know if anyone has a workaround where selecting the column highlights all the values, not just the "row" it belongs to.
It is difficult to say for sure without taking a look at your model. What fields are on the bar chart? If they are from different tables is there a relationship between them?
The bar chart just contains the error field as an implicit measure. This is the same field as the error column on the table visualisation.
Alright then, I believe what you would need to do is to put the error field on the "legend" well of the bar chart, and select the error field you want on the legend:
Versus just selcting the column:
Othen than this I got nothing, would be interested to know if anyone has a workaround where selecting the column highlights all the values, not just the "row" it belongs to.
Thank you - this works. I now have more than 1 error column. Is there a way of achieving this with multiple fields? I can only add one field to the legend.
Laura_May You should structure you table so that any other values you would like to be shown in this legend are also on the "error" column, if you're not too familiar with that this link may help you:
https://medium.com/@cherifal2011/normalization-and-denormalization-in-power-bi-295d4dfbf3ab
Basically you should only have one error column, and will probably have to pivot/unpivot your data in Power Query at some point; Same data point has two or more errors? Two rows on the table, one for each error ID, and you have a dimensional table containing all the Record IDs related to you fact table, and that is the field you'll use in any visual.