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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
fbottazzoli
Advocate I
Advocate 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.



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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.



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

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/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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