Table Visual value as Filter

@

vanessa Really interesting...Not sure if fit your needs but here it goes ( think is cool functionality )

I have only test it so it might need some tuning.

Reports can be filtered on the url., so create a calculated column in the source of the first page table ( i.e Car Brands ). Then you copy the 2nd report url and you add at the end the filter of brands

Filtered Report = 
"https://app.powerbi.com/groups/me/reports/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx?filter=CarBrands/Brand%20eq%20%   &   CarBrands[Brand]   & %27

Where xxxxxxxxxxxxxxx is the code from your report link  -   CarBrands/Brand = TableName/ColumnName  

%20 is space , %27 is  ' .

The actual format of the filter parameter is ?filter=CarBrands/Brand eq 'Audi'  and this is what we trying to manage. Get the Audi depending the value in the table.

Usually it works like that but sometimes is better to write it with url formating for spaces etc ( 20% )

Notice - the names of tables and columns cannot have spaces.

You can check these links

http://stackoverflow.com/questions/35555694/passing-parameters-to-power-bi-filter-programmatically

http://mmaitre314.github.io/2016/02/13/passing-report-filters-to-power-bi-using-urls.html

Now the easy part, you add the url column in your table and then go to table attributes and set url icon to On.

Now your table will look good also as when you click the url icon you and up in the filtered page report. There you can add a link to take you back to the first report with the Brand table.

I hope I make it clear enough.