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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors