How to get whole individual records when I select on a column in stacked bar chart

[GVenkatesh]

Hi 

In power bi report I have stacked bar chart 

when I click on 79.10% I need to get that particular records or when i select 20.90% I need to get that particular records .
for X axis I have used measures ,for Y axis I have created a table with only column names to display the column names like billing state ,customers only to build the stacked bar chart.Both X and Y are not form same table.
please help me out to solve this issue.

Thank you

[ThomasWeppler · Accepted solution]

Hi @GVenkatesh 
Have you tried. to add a table in your repport?

If you do just add all the data you need sorted to this table and it should work out when you press the 79.10% or the 20.90%

I hope this solved your problem 🙂