Power BI Line Chart - Add lines with different growth rates

[Nikhillearn]

Hello Experts, 

I am working on creating a line chart, it looks fine but i would also like to see what it would look like, if the growth rate is changed

Can this be achieved with Measures if we know the growth rates  ( example 10%, 15%, 5%)

[Icey]

Hi @Nikhillearn ,

Is this problem solved?

Best Regards,

Icey

[Icey · Accepted solution]

Hi @Nikhillearn ,

Please check:

10% Rate = 
VAR MinDate =
    MINX ( ALLSELECTED ( 'Table' ), 'Table'[Date] )
VAR MinDateActual =
    CALCULATE ( SUM ( 'Table'[Actual] ), 'Table'[Date] = MinDate )
VAR Rank_ =
    RANKX (
        ALLSELECTED ( 'Table' ),
        CALCULATE ( MAX ( 'Table'[Date] ) ),
        ,
        ASC,
        DENSE
    )
RETURN
    IF (
        MAX ( 'Table'[Date] ) = MinDate,
        MinDateActual,
        POWER ( 1.1, Rank_ ) * MinDateActual
    )

15% Rate = 
VAR MinDate =
    MINX ( ALLSELECTED ( 'Table' ), 'Table'[Date] )
VAR MinDateActual =
    CALCULATE ( SUM ( 'Table'[Actual] ), 'Table'[Date] = MinDate )
VAR Rank_ =
    RANKX (
        ALLSELECTED ( 'Table' ),
        CALCULATE ( MAX ( 'Table'[Date] ) ),
        ,
        ASC,
        DENSE
    )
RETURN
    IF (
        MAX ( 'Table'[Date] ) = MinDate,
        MinDateActual,
        POWER ( 1.15, Rank_ ) * MinDateActual
    )

BTW, .pbix file attached.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Nikhillearn , Are Rate 1, Rate 2 are measures or dimension values, what do mean by growth rate?

[Nikhillearn]

Hello Amit, 

Rate 1, Rate 2, Rate 3 are not measures yet. I would like to "add" these measures. I want to generate these values automatically probably with a dax formula. For example, Rate 1 is 10%. This means for that Y will be 10% more than previous value. Here are some sample values

X	Rate 1 ( 10% growth Rate)
1	1
2	1.1
3	1.21
4	1.331
5	1.4641
6	1.61051
7	1.771561
8	1.948717
9	2.143589
10	2.357948

[amitchandak]

@Nikhillearn , if you have column like X

new column = if([X]=1, 10, POWER(11, [X]))

[amitchandak]

@Nikhillearn , Can you share sample data and sample output.

[Nikhillearn]

Thank you Amit for the response i will try this