personalize slicer type

[Anonymous]

Hi,

I created slicer type: 'Relative Date'. I would like to allow users to change type to 'List' or 'Between'. I allowed personalize option for this visual and the users are able to change visual but not to change slicer type. What am I doing wrong?

As you can see on picture the option to change slicer type is missing and as for changing visual - I'm able to do this but when choose slicer - the same type of slicer is applied. Appretiate any help.

[amitchandak]

@Anonymous , check the option near to three dots a down arrow

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-slicer-numeric-range

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

[Anonymous]

Hi, three dots give these options

Slicer type is generally changes by this dropdown (see red circle in image below). Problem is I can't see this option in published report.

[amitchandak]

@Anonymous , look for down arrow , near to 3 dots and eraser. Hover near to corner

[Anonymous]

I can see this down arrow in pbi desktop. I can't see it in published report as I write earlier.

From what I can see, you are clicked on slicer visual, so your print screen are probably from pbi desktop. Problem is I want to allow to change slicer type for users who has access to this report. How to do that?

[amitchandak]

@Anonymous , do you have an edit report. Also check visual header need to be enabled

[Anonymous]

Visual header is enabled.

What do you mean by this: "do you have an edit report" - should I share pbix file?

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

First, If you want to change type of the slicer, you need to change it in edit view not read view. 

https://docs.microsoft.com/en-us/power-bi/create-reports/service-interact-with-a-report-in-editing-view

second, for your requirement, it couldn't achieve in personalize visual mode for now,

and a simple way, you could import some other slicer from marketplace. for example: Smart Filter by OKViz, which is list type.

Now you could switch them in personalize visual mode.

Regards,

Lin