Forum Discussion
Creating hierarchies (dragging and dropping) stopped working for some bizarre reason
- Anonymous5 years ago
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.
Ok so this has come back, when I try and drag and drop then I get a circle with a line through it. It isn't the connection type (am not a live connection). I just entered data into Power BI manually to try it. I disabled all of the preview features and uninstalled / installed - this is getting pretty frustrating!
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
- Anonymous5 years agoNot applicable
Thanks, this worked for me!
- sburden773 years agoNew Member
Thanks Brett, this worked for me too!