Skip to main content
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

New Member

Custom sort for multiple columns in same table



I have a survey feedback Table 1 that has multiple columns with same values, basically different questions with same set of answers to choose from (Strongly Agree, Agree, Disagree,Strongly Disagree)




I created a custom table (Table 2)  and created a relationship with  Column 1 of Table 1 .

The visual with Column 1 is now sorted. But I am unable to get the other Columns(Column 2, Column 3..) sorted that has the same set of answers since I cannot make the relationship ACTIVE between the custom Table (Table 2) and Column 2 Table 2.


There are atleast 10 colums with same set of answers and I need to sort each of them in the visual(x-axis). How can I achieve this?


Hope this makes sense.


New Member

Thank you for all the links but those were all multiple and vast topics that I am not really looking at this stage.


I want to custom sort the X-axis of 10 bar charts where all the X-axis has the following values -Strongly Agree, Agree,Disagree,Strongly Disagree.

I have created a custome sort Table and can only sort 1 bar chart using that custom sort table. I am unable to sort the remaining 9 bar charts.


Hi @BishN ,

Which table field be applied on X axis of 10 bar charts? Are they all from the field of custome sort Table? And how did you sort these 10 bar charts? Could you please share a simplified pbix file with the fake data and 10 bar charts in order to make troubleshooting and give you a suitable solution? You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

@BishN , You can create inactive relationships and activate that using userelationship in a measure and use that measure in visual

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


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