Forum Discussion
clarkson106
2 years agoFrequent Visitor
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 resul...
Daniel29195
2 years agoCommunity Champion
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
2 years agoCommunity Champion
- clarkson1062 years agoFrequent Visitor
Thanks for the reply. I will test it out and let you know how it goes