Forum Discussion
Matrix Column Head Order
- 9 years ago
Anonymous
We can do that with following steps. Assuming we have a table like below. We can add a reverse index.
Close and apply Query Editor, select the Type column and make it sort by column of Index.
Now the order of the column heads will follow the Index.
If you want to put it in a custom order, you can customize the index yourself. For example, you can create a conditional column in Query Editor.
Best Regards,
Herbert
Anonymous
We can do that with following steps. Assuming we have a table like below. We can add a reverse index.
Close and apply Query Editor, select the Type column and make it sort by column of Index.
Now the order of the column heads will follow the Index.
If you want to put it in a custom order, you can customize the index yourself. For example, you can create a conditional column in Query Editor.
Best Regards,
Herbert
- Anonymous8 years agoNot applicable
Is there a way to implement this when in Direct Query mode? I had it working in import mode, but now the needs of my project have required direct queries
- S1840198 years agoAdvocate III
I don't think this exists as of yet. I have been searching for a while. I even created my query to sort so that data would come into the query editor window in the proper chronologic order like this,
order by case when [Month] like '%Jan%' then 1 when [Month] like '%Feb%' then 2 when [Month] like '%Mar%' then 3 when [Month] like '%Apr%' then 4 when [Month] like '%May%' then 5 when [Month] like '%Jun%' then 6 when [Month] like '%Jul%' then 7 when [Month] like '%Aug%' then 8 when [Month] like '%Sep%' then 9 when [Month] like '%Oct%' then 10 when [Month] like '%Nov%' then 11 when [Month] like '%Dec%' then 12 end
Still nada! If this isn't a suggestion for an improvement, I don't know what is. :smileytongue:
- Anonymous7 years agoNot applicable
I solved it by sorting by another column that I called date order
- Anonymous7 years agoNot applicable
Hi,
I had a similar issue.
interestingly it is working for one Matrix and not for Another.
I have recheck each and everything.Any suggestions
- S1840197 years agoAdvocate III
Anonymous
There seems to be a bug in the order system. The way around it is to make sure that you have numbers as numbers, text as text, and dates as dates. Then make sure that you click on the field list on the right side. click on the field you want to be sorted. Then click off the field, but onto another field in the same table of the field list.
Then click back on the field and then the modeling should show up as sort by column. When it does, choose the field you want to sort the field by. So for example maybe you want to sort your organization by date. Click on org then off of org then back on to org. Then int he modeling tab at the top, the Sort by Column button will be available. Click on that and then chose date. This will sort your org by date. Hope this helps.
- Anonymous7 years agoNot applicable
Hi
Thanks S184019
I am able to achieve it.
But facing same issue for Horizontal Slicer visual.
I am also not able to get help with the Sort Option the visual provides.
I need to sort by Index which I have mentioned.
Could you suggest.
- Anonymous9 years agoNot applicable
Thanks Herbert...this should help quite a bit!
Tim
- yatinpurohit8 years agoHelper I
Thanks. This worked out perfectly.
- Anonymous7 years agoNot applicable
This solution is incorrect
- Anonymous7 years agoNot applicable
Hi,
I had a similar issue.
interestingly it is working for one Matrix and not for Another.
I have recheck each and everything.Any suggestions
- kbuckvol6 years agoAdvocate I
It's the little things, worked like a charm!