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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
yao_xiao
Frequent Visitor

PowerBI_How to rank a matrix title using a value not used in the matrix?

Hi everyone,

 

Could I please get some help with ranking the columns? I want the end result to be like this:

 

Company ACompany BCompany CCompany DCompany E
Number of ResponsesNumber of ResponsesNumber of ResponsesNumber of ResponsesNumber of Responses
5328 1

 

However, the columns need to be sorted by another measure ("Score") that is not used in this matrix. But if I add it into the matrix to be able to use it as a filter, it can't be simply hidden because it becomes like this:

 

yao_xiao_0-1750645425040.png

 

Could anyone help with showing a table/matrix with only one measure ("Number of Response") but ranked by another measure ("Score")? Thank you very much!

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but some visuals like column chart, you can try to insert scroe measure into the tooltip, and then sort the visuals by tooltip value.

 

Jihwan_Kim_0-1750647249826.png

 

 

Or, if you want to use matrix visualization, you can try to make Values -> text wrap off and Column headers -> text wrap off.

 

Jihwan_Kim_1-1750647345215.png

 

Please check the attached file, whether it suits your requirement.
Thank you.

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

4 REPLIES 4
Jihwan_Kim
Super User
Super User

Hi,

I am not sure if I understood your question correctly, but some visuals like column chart, you can try to insert scroe measure into the tooltip, and then sort the visuals by tooltip value.

 

Jihwan_Kim_0-1750647249826.png

 

 

Or, if you want to use matrix visualization, you can try to make Values -> text wrap off and Column headers -> text wrap off.

 

Jihwan_Kim_1-1750647345215.png

 

Please check the attached file, whether it suits your requirement.
Thank you.

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Hi @Jihwan_Kim ,

 

Thank you for your response!

 

I think the second method you suggested that is used on a matrix would usually work, and it probably works on yours. However, after I turned text wrap for both "column header" and "value" off and tried to minimise the "Score" column, the boundary of the column bounces back and the column is revealed again. Do you know what the problem is?

Hi,

I am not 100% sure without seeing your sample pbix file, but please try turn "auto-width" off.
 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Thank you for your response @JihwanKim !

 

I actually figured it out myself haha

 

The problem was solved by selecting "Switch values to row" on the Values setting on the Visual panel. Then it I can shrink the height of the matrix to hide the bottom row which is the measure I use to rank. 

 

But thank you anyway!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.