Forum Discussion
benqpbi
Helper I
Helper IHow to Sort in order correctly in visual
Why i am unable to sort in order of number 1 to 14, kindly help me on this. thanks
Hi,
One of ways to solve this is to create names like below.
Category SEQ01 SEQ02 SEQ03 SEQ04 SEQ05 SEQ06 SEQ07 SEQ08 SEQ09 SEQ10 SEQ11 SEQ12 SEQ13 SEQ14
Jihwan_Kim
Super User
Super UserHi,
One of ways to solve this is to create names like below.
| Category |
| SEQ01 |
| SEQ02 |
| SEQ03 |
| SEQ04 |
| SEQ05 |
| SEQ06 |
| SEQ07 |
| SEQ08 |
| SEQ09 |
| SEQ10 |
| SEQ11 |
| SEQ12 |
| SEQ13 |
| SEQ14 |
benqpbiHelper I
Helper Ican i create a calculated column the full name looks like
abc_prog_gig_seq1
till
abc_prog_gig_seq17
will switch( true(), ) work ?
thank you 🙂
- Jihwan_Kim
Hi,
Creating calculated column might be not efficient.
Please try changing a name in the source.
Or,
Please try chaging a name in Power Query Editor.
Please be noted that try using 01 02 03 04 05 .... not 1 2 3 4 5....
- benqpbi
can you pls help me out here pls, if possible 🙂
How to add value in column which is not consistent - Microsoft Power BI Community