So I have a report from where I want to drill through a different report.
The problem is that the Title field used as display repeats on different entries, Like this I need to drill by the ID (the only unique field), but this ID field is hard to read for the User.
how can I pass the ID from the selected column on the first report to the second report?
Adding white spaces helped solve the issue of the ID generation as there is currently no way for PowerBi to have the same title in different columns or dril through child columns
thanks to @user5226582