live connection SSAS cube - stacked column chart hide column programmatically

[MattiaMaetini]

Hi all,

I need to give to my end user the option to hide/unhide specific columns from a stacked column chart.

Right now, I create different bookmarks to obtain some similar results, but it frustraiting and time consuming.

I use a live connection to SSAS cube and I can't use Parameter fields: how could I try to do the same behavior?

BR,

M

[Anonymous · Accepted solution]

Hi @MattiaMaetini 

You can consider to change the connection mode from live connection to direct query mode so that you can use the field paramater, you can refer to the following solution to change the connection mode.

Click 'Change this mode' at the bottom right of Power BI Desktop.

Then select the table you need to connect.

Then you can change the mode to direct query mode and then you can use the paramater.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.