Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RodyHarper
Frequent Visitor

Allow users to choose type of date slicer

In Power BI Desktop I set the type of date slicer that the user interacts with.  Is there a way to allow a web/app user via power bi service to select/change this while using the report, without actually editing the report for other users? 

 

Most of the time the relative data is preferred...but occasionally more precise dates are needed, and it would be nice to allow the user to choose the type of date slicer during that scenario. 

 

 

RodyHarper_0-1607708336109.png

 

1 ACCEPTED SOLUTION

Hi @RodyHarper ,

 

Maybe everyone's opinion will be different, If you think it's necessary you could submit your ideas here.

Another alternative is to copy the report page, save the report in a different slicer format, and then add a bookmark to allow users to redirect to the report page in different slicer formats by selecting a bookmark.

Refer:https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
V-lianl-msft
Community Support
Community Support

Hi @RodyHarper ,

 

In Power BI service, You can click Edit Report, then you can choose different mode type for slicer visuals.

The same thread:https://community.powerbi.com/t5/Service/Date-slicer-type-not-visible-in-web-power-bi-after-publishe... 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the response.  Our organization is small, less than 50 people, and so far I am the main person who uses power bi desktop or uses the edit option in the web version.  Everyone else in the organization simply consumes the reports.  

 

So far I have created a filter in addition to the date slicer.  The filter allows for a date range, while the slicer is using relative dates.  The users change the slicer to include the subdate range they are looking for, and then use the filter to filter to the desired range.  

 

I still think this is suboptimal and allowing users to switch between the various date options seems like a good overall improvement to Power BI. 

Hi @RodyHarper ,

 

Maybe everyone's opinion will be different, If you think it's necessary you could submit your ideas here.

Another alternative is to copy the report page, save the report in a different slicer format, and then add a bookmark to allow users to redirect to the report page in different slicer formats by selecting a bookmark.

Refer:https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

collinq
Super User
Super User

Hi @RodyHarper ,

 

I assume that you mean for them to make the change on the Service, right?  Because if they have it in Desktop they can make that change.  As for letting them change a visual, there is the "Personalize Visuals" option.2020-12-11_16-50-01.jpg

 

I have used this in the past to let users make changes and I assume that it works on slicers as well.  Give that a try and let us know if it works on slicer visuals as well.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Thank you for the response.  Yes, I am referring to allowing the option to switch between the various date-selectors available in the slicer through the PowerBI service or more specifically through a Power BI App. 

 

I marked the customize visual, but it doesn't appear to do the trick.  

 

Thanks again for taking the time to respond! 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors