Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to Solution.
hi @vondravl
First, If you want to change type of the slicer, you need to change it in edit view not read 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
@vondravl , 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
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.
@vondravl , look for down arrow , near to 3 dots and eraser. Hover near to corner
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?
@vondravl , do you have an edit report. Also check visual header need to be enabled
Visual header is enabled.
What do you mean by this: "do you have an edit report" - should I share pbix file?
hi @vondravl
First, If you want to change type of the slicer, you need to change it in edit view not read 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
120 | |
112 | |
60 | |
59 |