assume u have this measure in ur bar chart:
this is how I would do it:
and color it by measure:
In that case, when u select a KPI, all the bars would still be shown, but only the one associated to ur selection would be colored; thus highlited
Thanks for your answer, however I do not think it gives me what I want.
By coloring it by measure each bar has a different column.
What I want:
By default (nothing selected in the table) every columns in the bar chart should have the same color.
If I choose KPI B in the table, the columns for 201806 and 201808 in the right bar chart should change color (because KPI B has comments for YearMonth 201806 and 201808), whereas the other column should keep the original color.
Hope it makes sense...
look the attached qvf! Do you want something like that?
It is almost like that, however is it possible to make it more dynamic. It should work the same way for the other KPI's, so if you fx. select KPI A it should color column 201804. But in the real dataset I have lots more KPI's, so is there another way instead of using nested IF's in the color expression?