Forum Discussion

Steveyd78's avatar
Steveyd78
Frequent Visitor
5 years ago
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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 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.

 

Refer to : https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#modeling-limitations

https://community.powerbi.com/t5/Desktop/Create-hierarchy-in-a-report-connected-to-a-SSAS-model/m-p/341958

 

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.