topic Customize the Relative Slicer in Developer

Customize the Relative Slicer

IoanCosmin — Thu, 19 Apr 2018 18:26:52 GMT

Hello,

I am wondering if there is a way to customize the basic Slicer visual. I am setting it to "Relative" and I would like to restrict what the end user is able to select. Instead of having 3 options (Last, Next, This), I want to remove the "Next" option. Also, it would be nice to restrict the other options (Days, Weeks, Weeks (Calendar), Months, Months (Calendar), Years, Years (Calendar)). I need that restricted to "Months (Calendar)". How can I customize it?

remove "Next"

The end users are not tech savy so I just want to make it easier for them by taking away selection that they will not have to use. I would like to keep using the Slicer visual instead of any workarounds because I want to be able to sync slicers across the report. I would be grateful for any suggestions.

Thank you,

Re: Customize the Relative Slicer

GRCacace — Fri, 20 Apr 2018 13:43:07 GMT

Well, I can tell you from personal experience that when the controls don't do quite what you want them to do, you have two choices: either you create your own custom visuals/controls (see Microsoft's documentation), or you build the filters outside of the report and use the API to set the filters after the user makes a selection.

In our case, we ended up embedding the report on a page, created our own custom filters, and then had those filters use the API to set the values in the PBI Embedded report. Our case was different because the filters have to limit the data in the report and in the other filters; imagine a product filter limiting the SKUs in another filter - and vice versa...and then those filters need to persist between different PBI reports. So, creating custom controls wasn't going to help us.

Hope this helps you!