Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to sort by quesiton but as you can see its not quite working out. Is there anythign I can do to fix this?
Solved! Go to Solution.
Hi, you need a extra column with the order.
Demo:
Question Order
Question 1 1
Question 2 2
Question 10 10
After that go to modeling Sort By Column and Select Order Column.
Hi, you need a extra column with the order.
Demo:
Question Order
Question 1 1
Question 2 2
Question 10 10
After that go to modeling Sort By Column and Select Order Column.
You can probably use the Query Editor to help you with this.
Highlight the column wtih the the text "Question 1" etc, then click the Transform tab and then the Split Column button to split by delimiter.
This will give you a new column with just the number component (so long as your data is consistent)
You can then set this solumn to be numeric and use this as your "Sort By Column" back in Power BI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |