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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
BishN
New Member

Custom sort for multiple columns in same table

Hi,

 

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)

BishN_0-1668667157726.png 

BishN_1-1668667179021.png

 

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.

 

3 REPLIES 3
BishN
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.

 

Anonymous
Not applicable

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

amitchandak
Super User
Super User

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

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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