I've created a straight table with several dimensions and expressions. Some of these dimensions and expressions are hidden.
When I added a new dimension, QV puts the dimension at the end of the table. Every time I want to drag and the the column to change the position, the column stays at the end of the table.
The only solution is that I recreate the table with al the expressions (+10 expressions) but after a few days the problem is back when I add a dimension
Or I create a expressions that contains only the new dimension and I hide the dimension and put that expression at the top.
Is this a common problem and can it be resolved?
Or did I do something wrong?
It happened in a few other dashboards too.
thx in advance
For this situation, please use FirstSortedValue() in expressions for column sorting. Use most granular field (AKA: Primary key) as the dimension and rest all of them as expressions.
Let me check if I have a sample App but this definitely works!
I don't understand what you mean.
It is not the sorting of the values of the columns but the position of each column.
I want to order the column as A, B, C but I keep getting A, C, B
I'm talking about the same thing. I'm not talking about the Row sorting. I'm talking about Column position sorting. This can be done by using FirstSortedValue().