Add an ittem to the current filter

[Danielktn]

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 previous one. I got it.

My problem is that i want to compare in the middle of both orange columns with the situation of december 2019 but as I have filtered the table with march I can not. I would need to add to the context the month of december as well as the one filtered with the slicer. 

Any ideas? I guess there is a simple way but I dont find it.

Thanks!

[Icey · Accepted solution]

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.

5. Test.

Best Regards,

Icey

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

[Danielktn]

Thanks it works perfect!

[Icey]

Hi @Danielktn ,

Please share me a dummy PBIX file, removing sensitive information, for test. And show me the expected results.

Best Regards,

Icey

[Danielktn]

Hi,

thanks a lot,

Please find the Dummy file with the explanations inside.

File 

KR