Forum Discussion

niculeica's avatar
niculeica
Helper I
1 year ago
Solved

Remove measure from one Column value section

Hi! Is it possible to remove a measure added in Values section of a matrix, but only from under one Column? Please see the screenshot below. Basicaly, I'd like _RAGBudget to be shown only under Start Date - Last Closed Month column, and remove it from Last Closed Month.

 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi niculeica ,

     

    You can create a new measure so that it displays values under special columns and blanks in other cases.


    You can refer to the following example:

    Measure 2 =
    IF(MAX('financials'[Product]) = "VTT", [Measure], BLANK())


    Then you can turn down its column width. Mouse over the right side of the column and drag the double-arrow criterion when it appears until it disappears. However, at this point the row spacing will be larger as a result, so a shorter name for it is recommended.

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

     

    Best Regards,

    Clara Gong

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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi niculeica ,

     

    You can create a new measure so that it displays values under special columns and blanks in other cases.


    You can refer to the following example:

    Measure 2 =
    IF(MAX('financials'[Product]) = "VTT", [Measure], BLANK())


    Then you can turn down its column width. Mouse over the right side of the column and drag the double-arrow criterion when it appears until it disappears. However, at this point the row spacing will be larger as a result, so a shorter name for it is recommended.

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

     

    Best Regards,

    Clara Gong

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