Filter a table by clicking on stacked bar graph

[Anonymous]

Hi,

We  have a table of 200 records and stacked bar graph with green and red color legend.

The requirement is, for suppose we have 100 records for green and 100 for red.By cliking on green portion of the stacked bar chart it has to filter the table to show only 100 records with green color.

Is this possible to achieve from Power BI.If yes, kindly let me know the solution.

Thank you in advance.

[Anonymous]

Hi @Anonymous ,

Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.

Best Regards

Rena

[Anonymous]

Hi @Anonymous ,

Whether the below screen shot is what you want? If yes, you can refer my sample file to do it.

If the above information can't meet your requirement, please provide some sample data(exclude sensitive data) and your desired result. Thank you.

Best Regards

Rena

[amitchandak]

@Anonymous , if you taking then as a legend and they are visible, you should be able to filter other visual based on that. Same visual it will hight light. If you filter this visual Have one table visual with background color based on conditional format and group with this visual on top 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-visuals

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Greg_Deckler]

@Anonymous - Yes, check out Page 37 of the attached PBIX file under my sig.