cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Filtros por periodo

Buenas, quiero agreagar un filtro por periodos :

El usuario seleccionar periodo actual (2020-06) y debe haber un text box que indique los meses que quiere analizar (por defecto 12)

 

ejemplo Analizar los ultimos 12 meses: 

El usuario selecciona 2020-06 y los graficos se deben llenar de los ultimos 12 meses. 

He probado con el slider, pero solo me filtra el periodo actual

 

Agradeceria su ayuda

3 REPLIES 3
Super User IV
Super User IV

@WilliamPowerBi , You have the option of range and relative slicer. As relative slicer does not work in this there is a challenge. Any power BI rolling formula will group all 12 months together.

 

The best way out is

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

 



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!

Community Support
Community Support

Hi @WilliamPowerBi , 

You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Good:
It is a scorecard with 3 graphics:
Graph 1: Shows sales for the year, so the filter must be from 2020-01 to 2020-06
Graph 2: Shows sales last 12 months, so the filter must be from 2019-06 to 2020-06
Graph 3: Shows sales Anio acts vs. Previous year, the filter must be current year (2020) and previous year (2019)

The user select a period: 2020-06
The other parameters are assembled (according to the graph), from parameter 2020-06

The user clicks on a button to see (they pass the calculated parameters to the filter)
Power Bi displays the graphics

The challenge is to calculate parameters, pass it to the filters

I hope you can help me

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors