Dear all,
I created a table, I want below questions to be sorted by Q1-Q10, not by below order, any one can provide soem detail solution? Thank you so much.
@xiumi_hou couple of suggestoin comes in mind
- add a zero in front of single digit Q1 will be Q01 and so on and it will sort out by itself
- if you still want to show Q1, Q2 with single digit, add another column with 0 padded like Q01 and sort your column with new column in modelling tab and then you will see single digit number are sorted correctly.
Did I answer your question? Mark my post as a solution.
Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@xiumi_hou couple of suggestoin comes in mind
- add a zero in front of single digit Q1 will be Q01 and so on and it will sort out by itself
- if you still want to show Q1, Q2 with single digit, add another column with 0 padded like Q01 and sort your column with new column in modelling tab and then you will see single digit number are sorted correctly.
Did I answer your question? Mark my post as a solution.
Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Microsoft Ignite
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
The largest Power BI virtual conference
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
