Questions on slicer filtering of Dynamic Axis chart

[Winniethewinner]

Hi everyone, 

I have an attached sample file. 

I created a calculated dimension table and added "both" directional relationship to the sample data, using the Index key. By doing so I achieved a dynamic chart by switching the Attribute value, and at the same time I can use the fields as slicer to filter the value as well. - This is exactly what I wanted to achieve. However, I encountered an issue below: 

In the real world, my dataset is using SQL querying from a darabase, and data table contains 4M rows. And I have 8 dynamic dimensions to be switched from, then the dimension table would size about 32M rows, this takes up a lot resource and slow down the performance - making the chart refresh slow when switching dimensions.

I'm wondering if there is a more optimized way, to achieve slicer filtering of Dynamic Axis chart. Thanks in advance.  

[lbendlin]

The ones in the top right corner of your matrix visual

you can hover over them to learn what they do.

- go up

- enable drill mode

- go down

- expand to next level

[Winniethewinner]

Oh I see. I have quite a few dimensions and wanted to give users a more dynamic chart, i.e. chart based on dimension selected, rather than fold all the dimensions under a hierarchy. 

Thanks for the advise though.  

[lbendlin · Accepted solution]

Enable "Personalize visuals"  and teach you users how to use that very powerful and flexible feature.

[Winniethewinner]

I just researched and this is definitely an interesting feature which I just learnt today! Thanks for the tips! 

[lbendlin]

You may want to teach your users about the hierarchy navigation arrows instead.  That way you don't need to do any setup and can save space, and your users can still "cycle"  through attributes.

[Winniethewinner]

Thanks @lbendlin , would you elaborate more on the hierarchy navigation arrows pls? Not really very familiar with that concept. Thanks in advance.