Forum Discussion

Nikhillearn's avatar
Nikhillearn
Frequent Visitor
6 years ago
Solved

Power BI Line Chart - Add lines with different growth rates

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 ...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

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.