Show anual percentage growth in a line chart

[avendanof]

I´m havin an issue trying to show a percentage anual growth using a line chart.

I have done this in a matrix using an expession like this

= Fields!Empresas.Value/sum(Fields!PrimerValorEmpresa.Value,"NombreNivel2Alt")*100

Where NombreNivel2Alt is a group value.

¿But is there a way to acccomplish something like this in a line chart?

The final chart shoud look like this:

What I have in the axis y are percentages of grouth from a base year with a specific value.

Each group has a departing value, and is the total group value.

Here you can see how it works:

This are the group values

And this are the rest of the data values which I use to divide by the group values:

The last column is the percentage.

Now I need to convert this to a line chart

Thanks for any suport on this.

[MFelix]

Hi @avendanof ,

Have you calculated the % column on your data? What does the model looks like?

[avendanof]

In my data I only have the number of empresas month by month, and I have no %, In the Mathix I´m calculating the % right there, but I can´t do the same in the line chart. I´ve made a workaround using sql. But I still wonder if there is a better way to do this using formulas. 

The model has three tables, the Dim_date table,  the fact table with number of empresas and the Dim_Typeofempresa table. The fact table has only four fields, an ID, dates, TypeofempresaID, and ammount of empresa.

[MFelix]

Hi @avendanof , 

Try the following code:

% Grothw = VAR basevalue =
    CALCULATE ( MIN ( 'Calendar'[Date] ), REMOVEFILTERS ( 'Calendar' ) )
RETURN
    DIVIDE (
        SUM ( Empresas[Empresas] ),
        CALCULATE ( SUM ( Empresas[Empresas] ), 'Calendar'[Date] = basevalue )
    )

Be aware that this is always based on the lowest date of your date, and not restarted every year.