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

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