Slider and PBIX modification error

[alishchytovych]

Hello,

We need to show dropdown slider with the dates (2018-01-02, 2018-01-03, ...) to an user with some date preselected. 

Due to the lack of the Slider default value setting flexibility we used to use direct modification of the Report/Layout file in the PBIX package (just set slider and corresponding queries values). Latest release breaks this functionality - file becames corrupted after the change of the Layout file. Is it because of some CRC / signature check implemented? Any ways to workaround it?

Maybe some alternative way exists (M script to set kind a "current date" is not an option - we need to show the date and allow user to select any other dates)?

[v-shex-msft]

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

[alishchytovych]

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.

[alishchytovych]

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). 

[alishchytovych · Accepted solution]

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.