topic Re: Slicer can't save user inputted values when switching page. in Custom Visuals Development Discussion

Slicer can't save user inputted values when switching page.

Sssman — Wed, 29 Jan 2025 10:49:43 GMT

Hi,

I have created this slicer with help of ChatGPT because the default range slicer wasn't providing some customizations I wanted. For the most part, it works as expected, except for one thing, when I input values to the Min and Max box, the filter works but if I switch the page and go back to the page again, the Min and Max box will not show the user inputted values but the filter will still be active.

I have uploaded the files here, can someone please help me save the user input values, I would really appreciate it.
https://github.com/suvojithaldar/CustomRangeSlicer

Re: Slicer can't save user inputted values when switching page.

dm-p — Wed, 29 Jan 2025 22:03:53 GMT

Hi @Sssman,

It sounds like you're restoring the filter state from the visual host correctly when your visual reinitializes on page change, so at least the visuals are filtered correctly. You will have the responsibility of updating your UI.

For any input elements, you'll need some logic in there to fill them in - there would be two ways I'd consider this:

If restoring from the persisted filter state is acceptable, process your filter JSON to obtain the min and max values and make these the initial values of the corresponding input elements.
If the exact values the user typed are what you want to store (as Power BI may adjust the persisted filter to suit the data and may not reflect the user's original input 100%). In this case, I'd consider this approach:
- Create properties to store the type values and persist them using the IVisualHost.persistProperties API.
- These properties can be read when your visual reinitializes and populates into the input elements similar to the above mechanism.
- Keeping these properties hidden from the user when you create your formatting model so they cannot be manually modified from the pane (this could be fine if you don't mind them being visible, but bear in mind that you'll need to 'sync' them both ways rather than assuming that they'll only be written to from the visual).

Good luck!

Daniel

Re: Slicer can't save user inputted values when switching page.

Sssman — Thu, 30 Jan 2025 19:34:19 GMT

Thanks a lot! I was able to save the user input using the first method that you suggested.