So I have data like the below. If I add the example of state as a filter with the below data I'll simply have 3 options to select from. Instead I'm trying to create a filter that simply lists all available options.
I have considered using a Parameter, however I need the filter to be multi select which parameters do not offer.
Unfortunately I do not have the ability to reshape this data due to the potential number of options per column that I need to filter on, (75+ on at least two). Which is why I'm asking this question. I was hoping there might be a solution similar to SSRS where I can populate my filter with Query B and use the results to filter back to Query A.
State NY PA FL SC NC WV TX CA
ID | State 1 | PA, NY, FL, SC 2 | CA, WV, PA, NY 3 | NC, SC, TX, FL, NY