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

Filtro de fecha (período)

Hola

Actualmente tengo la tabla DimDate de la que estoy usando el intervalo de fechas como filtro para mi panel. Quiero cambiar este filtro con el filtro que tienen los siguientes elementos

Hoy
Ayer
Esta semana
La semana pasada
Los últimos 14 días
Este mes
El mes pasado
Los últimos 30 días
Este año

¿Cómo puedo implementar el filtro de períodos anteriores en POWER BI?

1 ACCEPTED SOLUTION
Super User IV
Super User IV

@usmanrafiq , puede usar una segmentación de fecha relativa si funciona.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

referir este blog para la costumbre

http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-powe...

De lo contrario, tienen que crear una segmentación de medida como

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME

múltiples medidas pueden cambiar en función de la selección

Para los valores que necesita hacer referencia

https://www.youtube.com/watch?v=duMSovyosXE

Power BI — YTD
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — QTD
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — MTD
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Power BI — WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
Power BI — Day Intelligence
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5c3243d...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
Super User IV
Super User IV

@usmanrafiq , puede usar una segmentación de fecha relativa si funciona.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

referir este blog para la costumbre

http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-powe...

De lo contrario, tienen que crear una segmentación de medida como

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME

múltiples medidas pueden cambiar en función de la selección

Para los valores que necesita hacer referencia

https://www.youtube.com/watch?v=duMSovyosXE

Power BI — YTD
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — QTD
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — MTD
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Power BI — WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
Power BI — Day Intelligence
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5c3243d...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

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