Forum Discussion
Matrix Column Head Order
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
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.
So the challenge is on how to sort the values in slicer? If so, I found this:
- Create a new table (in query editor) that has a column of distinct values that you are using in your slicer.
- Add a numeric column using whatever logic you need based on the desired order.
- Close and Apply to load this new table to data model, then create a relationship to your fact table.
- Click on the new field of distinct values, then click on the Modeling tab and select Sort by Column. Choose the numeric column that you created to provide the order.
- Use this distinct list in your slicer.
Did this help?