Forum Discussion
Helper ISort table strings
In this scenario, if you don't want to sort the value in alphabet order, you must have an sort number column (like your Index column). You can have the TextString column sort by that index column and you don't need to put the index column into table visual at all. Just click the TextString field, then select the index column in "Sort by Column".
Regards,
Using your new text, I'm able to get the correct sort using my steps. Do you have the latest version of the Desktop program? What does the Order by look like within the Modeling tab?
This is what I started with:
This is the modeling tab:
And this is the visualization:
Additionally, if you want to use the long sentence and word wrap, you can use the custom visualization LongTextVisualizer: https://app.powerbi.com/visuals/
HTH,
Jessica
Advocate IHi Eva-Lotta,
You can sort the data by going to the Table view, Modeling tab, Sort By Column, as shown in the below picture.
Also, if you'd rather not add a row number in the text file, you can do that within Power BI by adding an Index column within the Query Editor > Add Column tab > Add Index Column.
HTH,
Jessica
Helper IHI Jessica,
And thanks for your propsed solution!
However, it does not really give me the result I'm after. This is what I have done in modelling:
And this is what the table visualization look like:
If I keep the Index column as visible in the Table visual, I can sort on that. But I don't want to display the index.
Did I interpret your suggested solution correctly?
//Eva-Lotta
v-sihou-msftMicrosoft Employee
In this scenario, if you don't want to sort the value in alphabet order, you must have an sort number column (like your Index column). You can have the TextString column sort by that index column and you don't need to put the index column into table visual at all. Just click the TextString field, then select the index column in "Sort by Column".
Regards,
- evalromf
Now, I got it to work! I missed to select the TextString column before Sort by feature.
My data submittors will be very happy to be able to enter their comments in a text file, as they are a bit old school :)
Thanks!
Eva-Lotta
- evalromf
I can also add that having the comments as a long text string instead of several different rows does not work (for me, at least). This leads to a "wide" table with a scroll bar, no page breaks.
It seems like there is no built-in feature to add word wrap yet: "We are starting to look into adding word wrap to tables, matrices and cards. While we don’t yet have a date to give you, I wanted to let you know that we are listening and we are starting to investigate this feature." (written in august)
//ELR
- jessicammoss
Using your new text, I'm able to get the correct sort using my steps. Do you have the latest version of the Desktop program? What does the Order by look like within the Modeling tab?
This is what I started with:
This is the modeling tab:
And this is the visualization:
Additionally, if you want to use the long sentence and word wrap, you can use the custom visualization LongTextVisualizer: https://app.powerbi.com/visuals/
HTH,
Jessica
- evalromf
The LongTextVisualizer is really great, thanks for recommending that! It really made my day :)
//Eva-Lotta