Drilldown by clicking on cell in Table visual

[amalekshahi]

I want to be able to click a cell in Table visual and see details for that cell. For example, if the Table contains # of customers who purchased umberalla and pen in U.S. cities (cities in rows and umerlla and pen in columns), I want to see list of customer names in Los Angles who bought pen, if user clicks on that cell.

Is this possible?

[Kopek]

Hi, has it been solved somehow ? I cannot find anything about it, and it will be really useful for me.. 🙂

[v-sihou-msft · Accepted solution]

@amalekshahi

Currently, it's not supported to drillthrough on cell level or edit cell within table visual like Reporting Service. Please submit a feature request on: https://ideas.powerbi.com/forums/265200-power-bi-ideas. You can also vote this idea.

Regards,

[parry2k]

Hi @amalekshahi

Power BI Desktop March update has something which can help you to achieve what you are looking for, there is a new visual "matrix preview" which allow to drill down and also cross filtering, check it out here.. 

[parry2k]

Unfortuately that is not possible at this point, you need to add slicer for each column on which you want to slice the data.