Decomposition tree sort variables and increase node width

[clarkson106]

I am using Direct query and have a decomposition tree like below.

1. I want the variable Year to be sorted in ascending order by year and not the number of sales in year. So in the example the results should be shown in the Year column in the order of 2018, 2019, 2020, 2021, 2022, 2023.

2. how to increase the width of nodes so that City_ company_level_1 and City_ company_level_2 headings will be shown in full rather than having ...

 

 

[Daniel29195]

Hello @clarkson106 

if this is what you want, 

you need to do the following : 

1. create w calculated column to rank the years . 

2. create a second caluclated column to rank the sales ( in each year ) 

create a third caluclated column to concatenate the 2 previosuly created columns . 

in the decomposition tree, add this measure in the tooltip ,  

then you order by this column .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Daniel29195]

@clarkson106 

keep in mind, that if you want the ranking to change base on your slicers, 

you need to create the sortings as measures not calucalted columns .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Daniel29195]

@clarkson106 

sorry didnt notice that you were using directquery, 

your only way is measures. 

[clarkson106]

Thanks for the reply. I will test it out and let you know how it goes

[sayaliredij]

Hi @clarkson106 

Oh Unfortunately i dont know how to add secondary sorting to decomposition tree. 

We can check with other experts in the community if they know anything

@amitchandak 

@Daniel29195 

@Fowmy 

@Greg_Deckler 

Thanks and Regards,

Sayali

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!! 

[sayaliredij]

Hi @clarkson106 ,

1. For sorting . please click on 3 dots and select sort by option select your desired sorting attribute

2. For showing whole name intstead of ....

Please go in formatting options 

select Options

and increse the size.

Thanks and Regards,

Sayali

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!! 

[clarkson106]

Thanks @sayaliredij. Sorry I had not made it clear in my post. So what I want is, whenever the variable Year is added into the tree it should be displayed as 2018, 2019, 2020 so on. But the other variables should be displayed sorted by the number of Sales. If I go with your suggestion of sorting by year, then all other variables are also sorted by year. I only want Year to be sorted by year and all other variables to be sorted by the number of sales. Is this possible?