Hi, I see a lot peripherally related to this, but haven’t found an answer yet. Can anyone provide one or steer me towards a resource?
I have 2 dim tables, location and person, plus fact table. I have a matrix and would like to use a slicer to dynamically switch between viewing by location then person, or by person then location. I imagine this involves switching the contents of the first two columns of the matrix and then using the stepped layout.
I can’t use bookmarks to switch between two matrix visuals because cross-highlighting is lost as soon as a visual is made invisible.
I appreciate any help. Thanks!