Custom sort for multiple columns in same table

[Anonymous]

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)

 

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.

[Anonymous]

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]

Hi @Anonymous ,

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]

@Anonymous , 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...