Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Format Panel

Hi everyone!

Do we have the possibility to enable/disable the switcher (Column subtotals) in format panel programmatically? After that, it should make an API call to powerbi.dataView and rerender the table.

 

Screenshot 2020-09-17 at 2.30.46 PM.png

1 ACCEPTED SOLUTION

Hi @Anonymous,

You can use persistObjectProperties on the visual host to do it. You send a VisualObjectInstancesToPersist object containing the object/property(ies) you wish to update and the visual host will set them and trigger an update/re-query (as any property change will do this), which would satisfy your requirement of updating the dataView.

Regards,

Daniel

 
 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

@dm-p 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Hi @Anonymous,

You can use persistObjectProperties on the visual host to do it. You send a VisualObjectInstancesToPersist object containing the object/property(ies) you wish to update and the visual host will set them and trigger an update/re-query (as any property change will do this), which would satisfy your requirement of updating the dataView.

Regards,

Daniel

 
 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Anonymous
Not applicable

@dm-p It works!! Thank you!)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.