Click on an aggregated bar to display unaggregated data

[lake_baikal]

Hi,

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.

[lbendlin · Accepted solution]

There are two options.  Read about "Drillthrough"  but also read about "Custom Tooltip pages" .  They eventually do the same thing, but Tooltips only require your user to hover over the bar to see the details while Drilltrough requires more clicks.