Format of highlighted items

[ruthhacche]

I have a BI bubble visual for my top 10 worst items. Each bubble is a different colour. I also have a Table of supporting data behind those bubbles. When I click on a bubble it filters the data table. All good and I am loving this. But just wondering if there is any way I can apply the colours used in the bubble visual to the lines in the data table visual. Or even Better a marker for the relevant colour as a column in the table - sort of like the markers used in the legend of the bubble visual. Just to further enhance the visual link between the two visuals. I suspect not but thought I would ask the experts.

 

[pbornemeier]

Turn on your macro recorder and click a few buttons. Post the result here along with a few lines of data (not a picture of the data) from your table and a narrative of what you were doing as each section of code was generated. What version of Excel are you using? Please include a few images of your setup as well. I may not be able to help, but more info might allow others to do so.

 

[sandy666]

@pbornemeier

BI bubble visual

this is in Power BI where vba is not (fortunately) accessible ?