Axis slicer in live connection mode

[jwang19]

Hi experts,

We are trying to rebuild a report by connecting a dataflow to a live connection to an SSAS model. Other charts and bookmarks work perfectly except for the field parameter function. We used to use parameters to allow users to dynamically change their columns and measures in a table.

Is there any workaround to create a similar axis slicer in live connection mode?

Below example is similar to what we need but we have a lot more selections.

BTW, some common solutions are not available in my case:

- With more than 30 columns and measures to choose from, it can be difficult to use buttons and bookmarks.

- Calculated tables aren't supported in live connection mode in my study.

Thanks in advance. 

[jwang19]

Thanks for the reply. It seems the only possible workaround currently.

Hope the parameter function can be supported in different connection mode in the future.

[lbendlin · Accepted solution]

Enable "Personalize visuals"  and teach your users how to use it.