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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors