Filtros por periodo

[WilliamPowerBi]

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

[dax]

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.

[amitchandak]

@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

[WilliamPowerBi]

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