Forum Discussion
Sorting
You have to create a Sort By column. For example, if you have a file with Jan, Feb, Mar, Apr, it will not sort by month date, but alphabetically, so Apr, Feb, Jan, Mar. Useless. You want Jan to sort by 1, Feb by 2, Mar, by 3, etc.
So create a column in your data set that has the desired sort you want. You have to create the column. You cannot sort your data and expect that to work. It won't.
Then use the Sort By Columns functionality. See this article for details.
Hi rrhascall ,
The viusal will sort by the columns in visual, so if you want to sort visual by specific in dataset, you need to set sort by in model like below
Then whe you use name column in visual, which will sort it by sort column.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You have to create a Sort By column. For example, if you have a file with Jan, Feb, Mar, Apr, it will not sort by month date, but alphabetically, so Apr, Feb, Jan, Mar. Useless. You want Jan to sort by 1, Feb by 2, Mar, by 3, etc.
So create a column in your data set that has the desired sort you want. You have to create the column. You cannot sort your data and expect that to work. It won't.
Then use the Sort By Columns functionality. See this article for details.
The sort column is already in my dataset. It is a numerical value and it is how I would like the data to be sorted. The visual I have created is ignoring this and only allows me to sort by the fields included in the visual. This is what I'm trying to resolve.
rrhascall wrote:The sort column is already in my dataset. It is a numerical value and it is how I would like the data to be sorted. The visual I have created is ignoring this and only allows me to sort by the fields included in the visual. This is what I'm trying to resolve.
What happened when you made it a "Sort By Column" per the article I linked to?
This feature really does work. I use it daily. We are trying to help you with how the product works.
So in a round about way that I don't like or recommend, if you are having this issue and the sort by function is not working the last resort is to include the sort by column in hte visual, click the column header to sort by it, and then change the font color to match the background.
I would go through the data and sort each column by the numerical sort column just to make sure first. Again, if your first column (the Row headers) are not sorted by the numerical sort column then it won't work in a matrix visual.
Hi rrhascall ,
The viusal will sort by the columns in visual, so if you want to sort visual by specific in dataset, you need to set sort by in model like below
Then whe you use name column in visual, which will sort it by sort column.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Have you already sorted your category column by your sort column? If so and the visual still ignores this sort, what visual are you using?
The Matrix visual lacks functionality. There are lots of ideas on the community site. Below are the front runners. Please vote these up!
