Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
yh1978
Frequent Visitor

MATRIX TABLE

Hi everyone,
I am new in POWER BI
And I have some questions.
I created a matrix table of salsePWER BI Q1.JPG 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

2 ACCEPTED SOLUTIONS
v-xuxinyi-msft
Community Support
Community Support

Hi @yh1978 

 

The following steps are for your reference:

 

Sample:

vxuxinyimsft_0-1716257119076.png

 

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:

vxuxinyimsft_1-1716257214041.png

 

question 2:

Right-click on the corresponding field

vxuxinyimsft_2-1716257285286.png

 

Or Double-click the corresponding field

vxuxinyimsft_3-1716257353787.png

 

Output:

vxuxinyimsft_4-1716257594876.png

 

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.

vxuxinyimsft_5-1716257658787.png

 

Output:

vxuxinyimsft_8-1716258953558.png

 

question 4:

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

vxuxinyimsft_7-1716258072498.png

 

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.

View solution in original post

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.

vxuxinyimsft_1-1716795975402.png

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

vxuxinyimsft_2-1716796219845.png

 

Output:

vxuxinyimsft_3-1716796345358.png

 

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

vxuxinyimsft_4-1716796495322.png

 

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.

View solution in original post

4 REPLIES 4
yh1978
Frequent Visitor

Thanks alot Yulia

v-xuxinyi-msft
Community Support
Community Support

Hi @yh1978 

 

The following steps are for your reference:

 

Sample:

vxuxinyimsft_0-1716257119076.png

 

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:

vxuxinyimsft_1-1716257214041.png

 

question 2:

Right-click on the corresponding field

vxuxinyimsft_2-1716257285286.png

 

Or Double-click the corresponding field

vxuxinyimsft_3-1716257353787.png

 

Output:

vxuxinyimsft_4-1716257594876.png

 

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.

vxuxinyimsft_5-1716257658787.png

 

Output:

vxuxinyimsft_8-1716258953558.png

 

question 4:

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

vxuxinyimsft_7-1716258072498.png

 

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.

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.
ThanksPOWER BI Q2.JPG

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.

vxuxinyimsft_1-1716795975402.png

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

vxuxinyimsft_2-1716796219845.png

 

Output:

vxuxinyimsft_3-1716796345358.png

 

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

vxuxinyimsft_4-1716796495322.png

 

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors