Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Format Panel

‎09-17-2020 04:36 AM

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

Message 1 of 4
6,705 Views
0
1 ACCEPTED SOLUTION
dm-p
Super User
Super User
In response to Greg_Deckler

‎09-17-2020 09:49 PM

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

Message 3 of 4
6,615 Views
0
3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

‎09-17-2020 06:00 AM

@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...
Message 2 of 4
6,667 Views
0
dm-p
Super User
Super User
In response to Greg_Deckler

‎09-17-2020 09:49 PM

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)




Message 3 of 4
6,616 Views
0
Anonymous
Not applicable
In response to dm-p

‎09-18-2020 01:16 AM

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

Message 4 of 4
6,601 Views
0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Kudoed Authors
View All