Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

measure parameter

I have a parameter in Power BI that I use as the Y axis of a line graph, and I have a measure that looks at this parameter and brings the equivalent value in the previous year, this value from the previous year loses its configuration (dynamic and percentage), how to solve ? Parâmetro 2 = { ("% Reclamações vs Nota Fiscal", NAMEOF('Calculos'[% Ocorr. vs Nfs Fat]), 0), ("Tempo Médio por Fila", NAMEOF('Calculos'[Média da Média calendario]), 1), ("Tempo Médio por Chamado", NAMEOF('Calculos'[Média Horas Fechamento Cliente]), 2), ("Quantidade de Reclamações", NAMEOF('Calculos'[Chamados Distintos2]), 3) } Grafico Linha Last Year = var selecao = SELECTEDVALUE('Parâmetro 2'[Parâmetro Pedido]) return IF(selecao = 0, [% Ocorr. vs Nf Last Year], IF(selecao = 1, [Media da Media Calendario Last Year], IF(selecao = 2, [Media horas fechamento cliente Last Year], IF(selecao = 3, [Chamados Distintos Last Year] ))))

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Anonymous 

    It's hard to help you solve the problem without simulated data, you can share the pbix file without sensitive data, data and the effect you want to achieve.

    Best Regards,
    Yang
    Community Support Team