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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
swifty250
New Member

Hierarchy on x-axis not displayed after moving to next level in hierarchy

Hi all, 

 

I would like to know if I can still view the hierarchy levels on the x-axis I have drilled through in a chart after using "go to the next level"  in the case where I want to skip a level.

Here is an example of the issue I am having.

The Hierarchy levels are as follows

  1. Weeks since receipted
  2. SITE
  3. Warehouse

The following image shows the top level. I choose to drill into the 0-12 weeks column.

swifty250_1-1677693541371.png

I have no problems, I get some nice x-axis labels for the hierarchy.

swifty250_3-1677693838200.png

 

However, if I choose to skip a level from here using "Go to next level in Hierarchy", I lose all x-axis hierarchy information even though i am still viewing a portion of the data that includes only parts delivered within the last "0-12 weeks"

 

I would like to have a number of hierarchy options that users can skip by if they do not want to slice the data in that way.

 

Hope that is clear, any help appreciated.

 

 

1 REPLY 1
lbendlin
Super User
Super User

Enable "Personalize visuals"  and teach your users how to use it. That way they can reswizzle all hierarchy items as they like.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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