Forum Discussion
Solved
Creating hierarchies (dragging and dropping) stopped working for some bizarre reason
Ok I all I am trying to do is to drag and drop one column onto another to create a hierarchy and it isn't letting me do it. I get a circle with a line through it indicating it isn't possible Anyt...
Hi Steveyd78 ,
Please check your connection mode.
Based on my test, custom hierarchy is not available in live connection mode.
And no built-in date hierarchy when you use Direct Query mode.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jpanzeca
Advocate I
Advocate IThere appears to be a better solution that sjrrkb123 showed me. They have moved this functionality to the Model tab.
Select your hierarchy and expand the Properties pane.
Thanks this worked for me, but make sure you click the Apply Level Changes once you have added and ordered your columns.