MATRIX TABLE

[yh1978]

Hi everyone,
I am new in POWER BI
And I have some questions.
I created a matrix table of salse with years (2022 vs. 2023)
And in addition, I created through a " quick measure" "year over year change"
Another column of gap in % was created.
My questions:
1. How do I create another column of the change in money (not in percentages)?
2. How do you change the titles in the created columns?
3. How can I sort the change column from largest to smallest?
4. How do I remove the unnecessary column created between 2022 and 2023?

Thank you all

[Anonymous · Accepted solution]

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.

[yh1978]

Thanks alot Yulia

[Anonymous · Accepted solution]

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.

[yh1978]

Hey
Thanks so much for your response.
You helped me a lot.
Question regarding removing an unnecessary column:
I intended to remove from the table only what I marked in yellow.
Thanks

[Anonymous · Accepted solution]

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.