Grafico en columnas con incremento arriba estilo think - cell

[fenix189222]

En powerBi quiero generar una visualizacion que sea un grafico de columnas comparativo de años de cada modelo de venta, en las columnas va a aparecer por cada año y modelo de venta el total de ventas, y luego lo que no consigo, es sacar para que arriba me de para cada año, el incremento respecto del año anterior. Que forma puedo hacerlo. Muchas gracias¡¡

[Anonymous · Accepted solution]

Hi @fenix189222 ,

You can try the visual: Inforiver Analytics+. It is the fastest way to visualize data and share insightful stories in Microsoft Power BI. The intuitive no-code user experience (UX) helps ordinary users build dashboards and storyboards in minutes, and integrates more than 50 charts and tables in a single visual.
This visual in it may meet your needs, and more details can be found at the link: Inforiver Analytics+ (50+Charts+Cards+Tables) (microsoft.com).

You can also create a measure yourself and use it as a tooltip for a column chart. More details can be found in the attachment.

MEASURE =
VAR _year =
    SELECTEDVALUE ( financials[Year] ) + 1
VAR _max_year =
    CALCULATE ( MAX ( 'financials'[Year] ), ALL ( financials ) )
VAR _sum1 =
    CALCULATE (
        SUM ( financials[ Sales] ),
        FILTER ( ALL ( 'financials' ), 'financials'[Year] = _year )
    )
VAR _sum2 =
    CALCULATE (
        SUM ( financials[COGS] ),
        FILTER ( ALL ( financials ), 'financials'[Year] = _year )
    )
VAR _sum = _sum1 + _sum2
VAR _sum11 =
    CALCULATE (
        SUM ( financials[ Sales] ),
        FILTER ( ALL ( 'financials' ), 'financials'[Year] = MAX ( 'financials'[Year] ) )
    )
VAR _sum22 =
    CALCULATE (
        SUM ( financials[COGS] ),
        FILTER ( ALL ( financials ), 'financials'[Year] = MAX ( 'financials'[Year] ) )
    )
VAR _cur_sum = _sum11 + _sum22
RETURN
    IF (
        MAX ( 'financials'[Year] ) = _max_year,
        BLANK (),
        DIVIDE ( _sum - _cur_sum, _cur_sum )
    )

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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