cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fbottazzoli
Helper I
Helper I

Dates slicer - Allow end-user to select the more appropriate kind of filter

Hi,

I'm using a Slicer object for allowing users to select the time interval they are interested in. I would like them to choose how to enter the date range, for example switching from Relative to Between options.

However, it seems this is not possible in reading view, but only in edit view.

Do you have any suggestion?

Thank you in advance for your help.

Francesca

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@fbottazzoli - Maybe try a couple bookmarks tied to buttons that swap out the slicers? So, 2 slicers stacked on top of one another configured in 2 different ways. Buttons that are tied to bookmarks that hide one and show the other.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

7 REPLIES 7
Greg_Deckler
Super User
Super User

@fbottazzoli - Maybe try a couple bookmarks tied to buttons that swap out the slicers? So, 2 slicers stacked on top of one another configured in 2 different ways. Buttons that are tied to bookmarks that hide one and show the other.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hola, buenas tardes! Probé la idea que planteas y no me ha funcionado no se si he hecho algo mal.

Mi idea es que el usuario final pueda elegir entre usar filtro de fecha relativa o filtro de fecha entre dos fechas. He añadido ambos filtros uno encima de otro y dos botones para cambiar de un filtro a otro usando marcadores (bookmarks). El problema que me surge es: si selecciono en el filtro de fecha relativa los dos últimos días y luego decido cambiar al filtro de fecha entre dos fechas y seleccionar cualquier periodo, se solapan los filtros indicandos en ambos y no se calculan las medidas que dependen de la fecha elegida.

¿Podeís ayudarme con esto?

Gracias de antemano

saludos

Hi @Greg_Deckler , thank you for suggesting this workaround 🙂

@fbottazzoli - Don't thank me yet, let me know if it works!! 🙂


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@fbottazzoli , please create an idea for that , check if there is already one https://ideas.powerbi.com/ideas/



Learn Power BI - Full Course with Dec-2022, with new DAX functions like Window, Index, Offset !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Formatted Profit and Loss Statement with empty lines

I created an idea for this: https://ideas.powerbi.com/ideas/idea/?ideaid=aeb7c181-77ee-ea11-bf21-0003ff52cdee 

Thank you for supporting it.

Francesca

Hiiiii, How are you?

I hope that It's all ok!

I'm insteresting in the answer of this answer but not is possible to me enter in the link.

Shall you help me? 

Best 

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Dev Camp Session 30

Ted's Dev Camp - January 26, 2023

This session will provide guidance and teach campers the skills required to build Power BI reports that support multiple languages.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.