cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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.


@ 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors