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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
emman_burgonia
Frequent Visitor

Arrange Columns in Matrix Visual and Show the Top 10 rows

Hi all, 

 

I have a question about arranging the columns in Matrix in Power BI. I have tried creating a new table with indeces however it's still not working. Is it possible that because the value are just the counts from another column? Here's the data I'm working with:

 

emman_burgonia_0-1663422587256.png

The idea of the table should look like this. 

emman_burgonia_1-1663422712724.png

Additional question: Is it possible to only show the Top 10 highest number of schools? The list seems long. 

 

1 ACCEPTED SOLUTION

Hi @emman_burgonia 

Please find the solution below and pbix file.
01.JPG

STEPS

Enter New Table and New Calculation Column for overwrite Other to Standard Enrollment

01.JPG

Change sort order

001.JPG

 

After that Add another calculated column in Data table to overwrite Other to Standard Enrollment
Create relationship
Plot data (find pbix)


Let me know, it works or not

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





View solution in original post

6 REPLIES 6
PijushRoy
Super User
Super User

Hi @emman_burgonia 

 

Please create a lookup table for "Enrollment Data Age" and add one column for "Sort"
Create a relationship with your data table
Use value from Lookup Table in Column for the Matric table and change the sort order.

For top10 highest number of school, you need to create RANK for the school and use the RANK in filter pane.

Hope you get idea to solve the requirement.
If you face any issue, please share sample PBIX after removing sensitive data.

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Hi @PijushRoy thanks for your assistance. I tried working on that but it seems that I cannot get the output that I want. I have attached here the link.

Hi @emman_burgonia 

Please find the solution below and pbix file.
01.JPG

STEPS

Enter New Table and New Calculation Column for overwrite Other to Standard Enrollment

01.JPG

Change sort order

001.JPG

 

After that Add another calculated column in Data table to overwrite Other to Standard Enrollment
Create relationship
Plot data (find pbix)


Let me know, it works or not

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Hi @PijushRoy

 

Thank you so much! This works perfectly. 

Hi @PijushRoy, can I ask how to use the RANK function to show only the top 10 cities?

@emman_burgonia 

Sure, I will share in some times

Please give Thumb UP, if my answer helps you




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.