Forum Discussion

LuisLOCapelari's avatar
LuisLOCapelari
Icon for Helper I rankHelper I
1 year ago
Solved

Annual comparison chart

Hello everyone, I'm Luis, Brazilian. I would like help creating a graph in which I can compare two years in two lines. I'm analyzing a company's revenue and I need to compare a desired year with any ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    1 year ago

    Hi LuisLOCapelari ,

     

    Try the following code:

    Medida Dinamica Outro Ano Acumulado = 
var AnoComparativo = [Valor Parâmetro]

RETURN 
CALCULATE([Medida Dinamica Comparativo Acumulado], DIM_DATA[Ano] = AnoComparativo , REMOVEFILTERS(DIM_DATA[Ano]))

    See file attach.

hirajazzi's avatar
hirajazzi
Regular Visitor
1 year ago

You're on the right track looking to visualize annual revenue side by side — creating an effective comparison chart is crucial for year-over-year analysis.