Forum Discussion

MattiaMaetini's avatar
MattiaMaetini
Icon for Helper I rankHelper I
2 years ago
Solved

live connection SSAS cube - stacked column chart hide column programmatically

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 frustrai...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.