I am fairly new to PowerBI, and am trying to implement something specific, but haven't been able to find an answer searching online. Basically, I have a Bar Chart containing aggregated counts, for example, the x-axis is products and the y-axis is number of vendors that sell each product. Basically, what I want is that if I click on a bar, let's say the bar for Product A, it would display a new table listing the unaggregated data for Product A, i.e. the names of the vendors selling that product.
Is there a way to implement this functionality in Power BI? If there is a more elegant way of handling this situation, feel free to suggest that as well.