MATRIX TABLE

Hi yh1978 

The following steps are for your reference:

Sample:

question 1:

If I understand correctly, you want to calculate the difference in Sales between years.

You can create a calculated column as follows.

Column = 
VAR _lastyear = 'Table'[Year]
VAR _sum = CALCULATE(SUM('Table'[Sales]), FILTER(ALLEXCEPT('Table', 'Table'[Department]), _lastyear - 1 = [Year]))
RETURN
IF(_sum = BLANK(), 0, [Sales] - _sum)

Output:

question 2:

Right-click on the corresponding field

Or Double-click the corresponding field

Output:

question 3:

Click on the "..." in the upper right corner of the visualization in the right corner of the visualization, select the fields you want to sort by and the way you want to sort them.

Output:

question 4:

Click the “×” to the right of the field you want to delete.

Please feel free to let me know if I have misunderstood you.

Best Regards,
Yulia Xu

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

Hi yh1978 

After my testing, the following method is for your reference. I'm afraid there is no other way.

Turn off the "Text warp" button.

Mouse over the rightmost part of the column and drag left until it is completely hidden.

Output:

If "Text warp" button don't be turned off, the effect will look like the picture below.

Best Regards,
Yulia Xu

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