Right click drill-through option not showing up in a table

[alexjoukova]

I have a table visual that contains columns Inspection ID, Inspection Date, Violations Count.
I want to be able to click on a row and drill through to the actual violation IDs. The drill-through option is not showing up when I right click though. How to fix this?

[Ritaf1983 · Accepted solution]

Hi @alexjoukova 

This is a question that is difficult to answer without seeing the file.

You need to make sure that there is a shared column/metric that you have defined in the drill column in the required place.
For example :

If I need to drill to "drill" page to see a value of the products as in attached picture :

I need to put the measure and the product as a drill field at the drill page:

for more information please refer to the linked video:

https://www.youtube.com/watch?v=BbplhqDCWOM

The small example of my pbix is attached too.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.