Forum Discussion
How to disable the automatic inline hierarchy???
- 9 years ago
Thanks LanceDelano! Seems, last service build 13.0.1605.489 works exactly as you promised!
But i'm have some question about buttons image quality. (see picture. This screenshot was made from Edge with 200% zoom)
Hi everyone! Thanks for the feedback. This is very helpful for us! I just want to let everyone know we hear you and are looking into this, both ways to improve the experience and giving y'all finer control over how the feature works.
zapppsr The fact that you are lossing your legend is a bug, we are looking into it right now and working on a fix.
Tishchenko, would you mind sending me your pbix file so we can investigate a bit more? You can send it to [email protected]. If you can't share it with me, could you send me some images that include the fieldwell of the column chart?
- zapppsr10 years agoKudo Collector
Hi Amanda, thanks for replying. It is always good to know there is someone looking our requests.
Regarding my chart, even if in that specific case it is a legend bug, on other charts where dates are not present, the new in-line hierarchy changed the context and even some numbers. Eg.:
If I had in the first level Cities, and on the second level Products, it would be like this:
Data:
City 1 - Product A = 10
City 1 - Product B = 20
City 2 - Product A = 100
City 3 - Product B = 200
Previous Drill Down method and In-line Hierarchy:
Level 1:
City 1 = 30
City 2 = 300
Level 2: - (Expand All Drill Down)
Product A = 110
Product B = 220
Level 2: - (In-Line Hierarchy Drill Down)
City 1 - Product A = 10
City 1 - Product B = 20
City 2 - Product A = 100
City 2 - Product B = 200
You can see, now, I miss some important information which was the sum of products, regardless the previous hierarchy.
As I mentioned before, congratulations, this is a new feature and very welcome, but not as a replacement for the old Expand All Drill down non-hierarchy bound. Specially when that change affect our reports in the middle of a meeting...
They are completely different ways of looking at data. And the old method is somehow more efficient in some scenarios, where I can have multiples charts in one, using the drill down.
I still advise adding a new button on the visuals allowing both drill downs (normal and in-line hierarchy) is the solution to benefit most people.
Do you know if this will be fixed only on next desktop release or will it be patched soon? At least if it is changed on the Power BI Online Service and you could spare us fixing some charts that would be great.
Thank you again for your help and please take our feedback as a means for improving this great tool which is Power BI.
- Anonymous10 years agoNot applicable
Great Point zapppsr. The change in the actual numbers is a big impact as well.
- Amanda10 years agoMicrosoft Employee
Thanks zapppsr for this great example! We actually used your example in our conversations here. :smileyhappy: As Alex mentioned, we are looking to release an update for this as soon as possible and are investigating options. You should hear something from us again in the next several days with a better estimate as to when the update will occur.
- SKM_Data10 years agoAdvocate II
Hey Amanda, Is there an update as to when this issue will be resolved? All of my expand down layers in all of my visuals no longer make sense because of in-line hierarchy being applied when my data isn't truly a hierarchy (they are distinct layers/angles at which we look at data).
Thanks!
Sean
- Tishchenko10 years agoResponsive Resident
Hi, Amanda, can't send my PBIX, but simalar behavior you can investigate on Microsoft Solution Template "Campaign/Brand Management for Twitter" https://powerbi.microsoft.com/en-us/solution-templates/brand-management-twitter/