cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Steveyd78
Frequent Visitor

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

 

Anything up with the latest release or is it just me?

1 ACCEPTED SOLUTION
Eyelyn9
Community Support
Community Support

Hi @Steveyd78 ,

 

Please check your connection mode.

 

Based on my test, custom hierarchy is not available in live connection mode.

3.1.1.live.PNG

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-limitation...

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

 

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.

View solution in original post

8 REPLIES 8
jpanzeca
Advocate I
Advocate I

There 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.

jpanzeca_0-1630080765515.png

 

Thanks this worked for me, but make sure you click the Apply Level Changes once you have added and ordered your columns.

Steveyd78
Frequent Visitor

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

Thanks, this worked for me! 

Steveyd78
Frequent Visitor

I wan't in live connection mode so a restart fixed the problem BUT I didn't know that live connection impacts the behaviour so that is really good to know

Eyelyn9
Community Support
Community Support

Hi @Steveyd78 ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

 

Best Regards,
Eyelyn Qin

Eyelyn9
Community Support
Community Support

Hi @Steveyd78 ,

 

Please check your connection mode.

 

Based on my test, custom hierarchy is not available in live connection mode.

3.1.1.live.PNG

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-limitation...

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

 

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.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.