Lookup solution

[Markzolotoy]

I have a clustered column chart that is a based on a master table. I also have a detail table. The relationship is set between the tables. I am adding a table visual that shows data from the detail table. When I click on a column in the chart the table shows filtered records based on the relationship key value. So, it's all good. What I want is to have buttons outside of the chart which would do the same as columns clicks. Can someone help me with the right direction?

Thanks

[Ashish_Mathur]

Hi,

A simple slicer should work.

[PhilipTreacy · Accepted solution]

Hi @Markzolotoy 

Download example file

If a basic slicer isn't suitable and you really want buttons you could use the Chiclet Slicer for this.  

Chiclet Slicer (microsoft.com)

regards

Phil