Show Percent of Total values in a Line Chart by Year

[AlejandroPCar]

Hi!

I have a measure of Percent of Total and works fine, but when I put that measure in a Line Chart dosent show me the correct values. I mean in 2015 the percent of some region's GDP in the total country's GDP was 25% and in the 2014 was 23% and 2013 was 21% and so on. I want these values in a Line Chart.

How can I do that?

Here is my pbix file if it will be necesary https://1drv.ms/u/s!AtTnrgPUQzQCgyIOQaCQ4q9M5tZW

Thanks for read me!

[Vvelarde · Accepted solution]

@AlejandroPCar

Hi, change your measure to this:

Aporte al Crecimiento Anual =
IF (
    OR (
        [Variacion PIB Anual] = 0;
        ( CALCULATE ( [Variacion PIB Anual]; ALLSELECTED () ) ) = 0
    );
    0;
    DIVIDE (
        [Variacion PIB Anual];
        CALCULATE (
            [Variacion PIB Anual];
            ALLEXCEPT ( Tiempo; Tiempo[Año] );
            ALL ( 'Geográfico' )
        );
        0
    )
)

[AlejandroPCar]

Hi @Vvelarde

Thanks so much!

It works!