Forum Discussion
Decomposition tree sort variables and increase node width
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 ...
7 Replies
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!!
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?
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! 🤠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! 🤠
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
Thanks and Regards,
Sayali
Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!
