Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
v-eqin-msft
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

9 REPLIES 9
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 Brett, this worked for me too!

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

v-eqin-msft
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

v-eqin-msft
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.