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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jnd27
New Member

Sorting Matrix - Word then Text

Hi, a quick question I have:

 

I have a matrix like this

 

Fruit     Code    Dollars
--------------------------
Apple    A1       (blank)
Total     Total    $3
Orange  O1      (blank)
Orange  O2      (blank)
Orange  O3      (blank)
Total      Total    $15
Pear       P1       (blank)
Pear       P2       (blank)
Pear    (empty)  $5

I want all of the Total lines to show up before the list of Fruit and Codes in the matrix: looking like this
Fruit     Code    Dollars
--------------------------
Total     Total     $3
Apple    A1       (blank)
Total     Total     $15
Orange  O1      (blank)
Orange  O2      (blank)
Orange  O3      (blank)
Total     Total     $5
Pear       P1       (blank)
Pear       P2       (blank)

I did non-summarize Dollars so everything would show up since there are blank cells, but how would I get the total line before the list in each instance? Thank you so much

5 REPLIES 5
audreygerred
Super User
Super User

Hello! In you matrix visual, go to the Row Headers formatting and turn stepped layout to off. Next, go to the Row subtotals formatting, toggle Per row level to On

audreygerred_0-1714487543434.png

Then, change Position from Bottom to Top

audreygerred_1-1714487588135.pngaudreygerred_2-1714487605574.png

Viola! Your totals are on top:

audreygerred_3-1714487638885.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Hi sorry, it's actually a table - all columns. How would I do it then? Thanks so much

I would do it as a matrix instead - you get the addional functionality like this.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Tahreem24
Super User
Super User

@jnd27  Try to configure these two setting in Matrix visual:

1. Go to Row Header property --> Option --> Turn off Stepped Layout

Tahreem24_0-1714487404382.png

 

2. Go to Row Subtotal --> and make sure to apply below setting

Tahreem24_1-1714487469696.png


Final Result will look like this:

Tahreem24_2-1714487523790.png

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Hi sorry, it's actually a table - all columns. How would I do it then? Thanks so much

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.