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.
Hi,
I'm no expect but i had this issue and found a work around that helped me.
Instead of using the drag drop method, i instead would right click the field i wanted and select "Create Hierarchy", and any additional field i wanted to add i would right click that and select "add to hierarchy"
Hope this helps,
Brett
Thanks Brett, this worked for me too!