Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
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
@BishN , You can create inactive relationships and activate that using userelationship in a measure and use that measure in visual
User | Count |
---|---|
122 | |
97 | |
89 | |
77 | |
68 |
User | Count |
---|---|
139 | |
115 | |
114 | |
98 | |
98 |