I'm wondering if it's possible to have a value in a table visual by a hyperlink with dynamic parameters that will populate another table visual when clicked? For example, table 1 has colums of "item desc", "date", "qty sold", "qty returned" with rows of "pink bikes", "2022-08", "5", "3"; "pink bikes", "2022-07", "8", "1"; "blue bikes", "2022-08", "18", "2".
When the second row , column "qty sold" of "pink bikes" is clicked, table 2 visual would display the customers who bought pink bikes in July of 2022. But, if they click second row, column "qty returned", table 2 visual would display the customers who returned pink bikes in July of 2022.
The first table is rolled up within the underlying sql, so I'd need to pull from a separate underlying data table with the information. Any ideas on how to do this? I'm happy to get into a video that's already available.
