Forum Discussion

Danielktn's avatar
Danielktn
Frequent Visitor
6 years ago
Solved

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 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!

 

 
 

 

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

     

    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.

4 Replies

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    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.

     

    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.

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

    Hi Danielktn ,

     

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

     

     

    Best Regards,

    Icey

    • Danielktn's avatar
      Danielktn
      Frequent Visitor
      6 years ago

      Hi,

      thanks a lot,

      Please find the Dummy file with the explanations inside.

      File 

      KR