Forum Discussion
Slider and PBIX modification error
I've ended up with the UI Automation to refresh and publish data and calculated column for Slicer to calculate "Current Period".
It would be great to have native support of the Slicer's default value and PBIDesktop API (as MS Office provides) to simplify business process automation.
HI alishchytovych,
AFAK, current power bi still not support setting default value. I'm not recommend you to modify pbix internal file to enable the default value, these operations may highly possible to broken original pbix file.
In my opinion, I'd like to suggest you vote below idea to help power bi dev team aware importance of below feature: (it already has 900+ votes)
Default Selected Slicer or Tile-By Value Configuration
Regards,
Xiaoxin Sheng
Thank you for the recommendation. I would appreciate to get suggestion how to create working solution as soon as possible.
Another (possible) approach to get HTML/DOM from Chrome_RenderWidgetHostHWND PBIDesktop window. Will explore this way.
Nicefinding - if UI Automation framework enabled tool is started prior to PBIDesktop.exe, then PBI runs Chrome (WebKit?) with Accessibility enabled option and all reports elements became accessible via UI Automation.
Unfortunately, there are no useful controls imlpemented for the Slicer (e.g. SetValue).
I've ended up with the UI Automation to refresh and publish data and calculated column for Slicer to calculate "Current Period".
It would be great to have native support of the Slicer's default value and PBIDesktop API (as MS Office provides) to simplify business process automation.