Add an ittem to the current filter

Hi, I have a report where I filter for a month all the financial info for example may comparing it with the previous year. I want to make a bridge graphic between current year and the pre...

Need Help

Icey

6 years ago

Hi Danielktn ,

Please check:

1. Enter data.

DataTypeWithDIC:

2. Sort column.

3. Create a measure.

Measure =
SWITCH (
    MAX ( DataTypeWithDIC[Data Type With DIC] ),
    "R19", CALCULATE ( SUM ( Tabla1[k€] ), Tabla1[Data Type] = "R19" ),
    "R20", CALCULATE ( SUM ( Tabla1[k€] ), Tabla1[Data Type] = "R20" ),
    "DIC19", CALCULATE (
        SUM ( Tabla1[k€] ),
        FILTER (
            ALLEXCEPT ( Tabla1, Tabla1[Concepto] ),
            Tabla1[Data Type with dec] = "DIC19"
        )
    )
)

4. Create visual.