topic Re: How to change sort value in dimension in DAX Commands and Tips

How to change sort value in dimension

cuneytk — Fri, 29 Jan 2021 07:41:00 GMT

I have 2 dimensions.

First dimension is projects sorted by earned money.

Second one is months. It should be sorted by month (january, february,...december) not earned money.

When i sort the visual by earned money, also second dimesion is sorting by earned money.

How can i do that?

Re: How to change sort value in dimension

rfigtree — Fri, 29 Jan 2021 08:05:21 GMT

probably need to define your problem a little clearer.

Re: How to change sort value in dimension

SpiroswayGR — Fri, 29 Jan 2021 08:39:02 GMT

Can you some some sample data and screenshots ?

Re: How to change sort value in dimension

cuneytk — Sat, 30 Jan 2021 10:05:18 GMT

First dimension is;

I want to sort by months in the second dimension (january, february, ... , december)

However, when user goes to second dimension, project revenues will be sorted by total revenue(i dont want this)

Second dimension looks like;

As a result, projects should be sorted by total money in the first dimension. (it's ok)
monthly income of projects should be sorted by month (january, february, march, ... , december) (i couldnt do this)
How can i solve this issue?

Re: How to change sort value in dimension

cuneytk — Tue, 02 Mar 2021 20:52:47 GMT