Forum Discussion

joel121960's avatar
joel121960
Icon for Helper I rankHelper I
2 years ago
Solved

agregar una linea de total

Tengo la siguiente grafica necesito agregar  una linea donde muestre el total   de los 3  (CW,PJ,PP) me podrian ayudar como hacerlo . 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi joel121960 

     

    Thank you very much lbendlin for your prompt reply. Allow me to add a few things.

     

    Here's some dummy data

     

    “Table”

     

    You can create a column or measure:

     

    Total Column = 'Table'[CW] + 'Table'[PJ] + 'Table'[PP]

     

    Total Measure = SUM('Table'[CW]) + SUM('Table'[PJ]) + SUM('Table'[PP])

     

     

    Here is the result.

     

     

    Regards,

    Nono Chen

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

2 Replies

  • Use a stacked area chart visual instead, or a ribbon chart visual

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi joel121960 

     

    Thank you very much lbendlin for your prompt reply. Allow me to add a few things.

     

    Here's some dummy data

     

    “Table”

     

    You can create a column or measure:

     

    Total Column = 'Table'[CW] + 'Table'[PJ] + 'Table'[PP]

     

    Total Measure = SUM('Table'[CW]) + SUM('Table'[PJ]) + SUM('Table'[PP])

     

     

    Here is the result.

     

     

    Regards,

    Nono Chen

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