Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there a way to change the order of the column heads in a Matrix table. Currently it displays in alphabetical ascending order. I would like to reverse that if possible. A prefered option would to be able to put it in a custom order. Are either of these options available?
Solved! Go to Solution.
@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
This solution is incorrect
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
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.
I solved it by sorting by another column that I called date order
@Anonymous
Hey I agree there are work arounds. I solved it the same way. Most things MS are Drag and Drop and I am hoping to usher that same motif into life here.
Thank you for a great suggestion!
Thanks. This worked out perfectly.
Thanks Herbert...this should help quite a bit!
Tim
Hi There,
You can drag your column fields in matrix visuals up and down to see the expected result.
Thanks & Regards,
Bhavesh
Hi there,
can you please share some screenshot for this, thanks in advance
Bhavesh,
The columns are not seperate categories in different columns...as shown below they are retailers all contained in one data tables column.