Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamically select what the (multiple) filters/slicers will be

Hey there,   I am working on a report in which I want to reveal some interesting relationships in our dataset.   Let's say I have this table:    A  B  C  D (<attributes) 1 (values in table) 2 ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

Try to edit the option. For more details, please check the online document.

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

With the dataset below I know I could use create 4 slicers 'Color', 'Rating', 'Size' and 'Type' and it still fits on the screen. But with the real dataset I'm working with I have between 100 to 110 filters, and everytime you want to filter on totally different columns.

 

Maybe I need to change the datamodel somehow, 'dynamically' cut the columns in 100 to 110 different tables, but I hope not. Since that would raise more questions.

 

So the story goes as the following:

 

 

 

 

Within the red boxes I want to select the filter I want to use, so you can select the value in the blue boxes.However, as soon as I select 'Type', it already shows 0 results.The datasetThe relationship works both ways