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/

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 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!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.