Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

MEGA QUESTION FOR MATRIX VISUAL

Hi community,

 

I have a question that Im affraid is not possible to be answered unless someone mega PRO. (crossing fingers)

 

I need to add 2 columns in my Matrix only for december and not to be in the total.

 

Anybody has an Idea how I could possibly solve something like this at least close to a solution?

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous

    You may try this simple way as below:

    Step1:

    Select matrix visual then Format->Column headers->Word wrap, disable it.

    Step2:

    Add a measure for "two columns" like this 

    Measure 3 = CALCULATE(SUM(Table1[Qty]),FILTER(Table1,MONTH(Table1[Date])=12))
    Step3:
    Drag the measure into value and set width for october and November like this:
     

    Best Regards,

    Lin

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous

    If I understand correctly what you need, I think we solved something similar in this post.

    Check it out.

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    HI, Anonymous

    You may try this simple way as below:

    Step1:

    Select matrix visual then Format->Column headers->Word wrap, disable it.

    Step2:

    Add a measure for "two columns" like this 

    Measure 3 = CALCULATE(SUM(Table1[Qty]),FILTER(Table1,MONTH(Table1[Date])=12))
    Step3:
    Drag the measure into value and set width for october and November like this:
     

    Best Regards,

    Lin