Hi! I could really use your help with this!
What I am trying to do is use this square shape visual (with text in the center) and I want to be able to use the set action filter to filter down to sub-category. It seems to be working but the squares get really tiny and distorted. Is there a way to get this to show up properly? If not, if anyone has any other ways to get around this (besides using the tree-map or bubble chart) I would greatly appreciate you feedback.
Another option that came up is to do a sort of sheet swap, but when you do that, it shows both sheets, where all I want to be able to do is see the one sheet without having to use a parameter to swap the sheets.
Thank you!! I attached a workbook.
Hi Peter!
So what I want is to be able to only see the bottom sheet when I click on the top sheet and vice versa and have it filter each other with the set actions (See image 1). Or to be able to have the set actions filter this way somehow (See image 3) but using a shape (square in rows and columns) instead of a tree-map or a bubble chart.
Image 1
Image 2
