Data Export though "Drill through" option in a Matrix Chart

[Anonymous]

I have a Matrix Chart which displays count for the 2 dimensions represented in it. I have set up a separate Table which can be accessed through "Drill through" option and then data can be exported. 

But issue is when the User wants to export for more than one of the column values the "Drill through" option is not enabled. "Drill through" is only accessable through one cell of the matrix chart. I ideally need it to be enabled even if all the column counts are selected. Its normally available in Tableuau but need help in achieveing that.

"Drill through" for a single selection:

"Drill through" not enable for a multiple selection:

I know that 'Show data point as a table' will display all the data, but it also displays all the calclulations and extra features which should not been seen by the users.

[v-eqin-msft]

Hi @Anonymous ,

To my knowledge,currently Power BI does not support Drill through with multiple selected values .

I have found some submitted ideas about this issue, please vote them up :

Multiple Values(row) Passing in Drill through feature

Drill through of multiple rows .

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt there is the option of drill through with multiple select, I tried control and click in table visual and post that there was not drill through option