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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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!:
The Definitive Guide to Power Query (M)

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!:
The Definitive Guide to Power Query (M)

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!:
The Definitive Guide to Power Query (M)

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors