Forum Discussion
moth change
hiii
i want a line graph which needs to display past 2 months data and present month data based on the slicer selection
like if i select april my line graph should display feb march and april data
of raw sla% , m.sla% and call closed
how can i do that can some one show that
https://drive.google.com/file/d/1lTcK5CQsdl3rteKc5GLimkEmjcjPDGR7/view?usp=sharing
@greeshma No pude abrir el archivo ya que tengo la versión anterior de Power Bi. Pero puede consultar los siguientes enlaces para su problema
https://stackoverflow.com/questions/49146565/show-last-3-months-from-selected-month-in-power-bi
https://radacad.com/only-get-the-last-few-periods-of-data-into-power-bi-using-power-query-filtering
2 Replies
- negi007
Community Champion
@greeshma No pude abrir el archivo ya que tengo la versión anterior de Power Bi. Pero puede consultar los siguientes enlaces para su problema
https://stackoverflow.com/questions/49146565/show-last-3-months-from-selected-month-in-power-bi
https://radacad.com/only-get-the-last-few-periods-of-data-into-power-bi-using-power-query-filtering
Hola @greeshma ,
1.Si desea mostrar datos de más de 2 meses, debe asegurarse de que los valores de filtro de la segmentación de datos no estén relacionados con los datos de ejemplo.
2.Crear yearMonth columna para la segmentación de datos.
Table = ADDCOLUMNS ( FILTER ( VALUES ( Query1[Call Closed] ), [Call Closed] <> BLANK () ), "Year", YEAR ( [Call Closed] ), "Month", MONTH ( [Call Closed] ), "YearMonth",YEAR([Call Closed])&"-"&FORMAT([Call Closed],"MM" ) )3.Dos medidas son estas.
M.SLA% = VAR _sel = SELECTEDVALUE ( 'Table'[YearMonth] ) RETURN CALCULATE ( IFERROR ( ( Query1[M HIT] / Query1[M.COUNT] * 100 ), 100 ), FILTER ( 'Query1', ( ( MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) || MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) - 1 || MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) - 2 ) && YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) && VALUE ( RIGHT ( _sel, 2 ) ) IN { 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 } ) || ( VALUE ( RIGHT ( _sel, 2 ) ) = 2 && ( ( YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) && ( MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) || MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) - 1 ) ) || ( ( YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) - 1 && ( MONTH ( 'Query1'[Call Closed] ) = 12 ) ) ) ) ) || ( VALUE ( RIGHT ( _sel, 2 ) ) = 1 && ( ( YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) && ( MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) ) ) || ( ( YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) - 1 && ( MONTH ( 'Query1'[Call Closed] ) = 12 || MONTH ( 'Query1'[Call Closed] ) = 11 ) ) ) ) ) ) )RAW SLA% = VAR _sel = SELECTEDVALUE ( 'Table'[YearMonth] ) RETURN CALCULATE ( IFERROR ( ( Query1[RAW HIT] / Query1[RAW COUNT] * 100 ), 100 ), FILTER ( 'Query1', ( ( MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) || MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) - 1 || MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) - 2 ) && YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) && VALUE ( RIGHT ( _sel, 2 ) ) IN { 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 } ) || ( VALUE ( RIGHT ( _sel, 2 ) ) = 2 && ( ( YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) && ( MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) || MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) - 1 ) ) || ( ( YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) - 1 && ( MONTH ( 'Query1'[Call Closed] ) = 12 ) ) ) ) ) || ( VALUE ( RIGHT ( _sel, 2 ) ) = 1 && ( ( YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) && ( MONTH ( 'Query1'[Call Closed] ) = VALUE ( RIGHT ( _sel, 2 ) ) ) ) || ( ( YEAR ( 'Query1'[Call Closed] ) = VALUE ( LEFT ( _sel, 4 ) ) - 1 && ( MONTH ( 'Query1'[Call Closed] ) = 12 || MONTH ( 'Query1'[Call Closed] ) = 11 ) ) ) ) ) ) )Puede descargar esto para comprobarlo.
Saludos
Stephen Tao
Si este post ayuda,entonces considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.