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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Mohammadwazeri
Helper II
Helper II

Drill Up, Drill Down and Next Level Hierarchy in Don't Turn Off

Hi Guys,

 

I am using "Stacked Column Chart," and I am trying to turn off the "Drill Up, Drill Down, and Next Level Hierarchy", but the options in the setting don't work. In the snapshot below I turned those off, but they are still showing up.

Does anyone have any idea?

 

Mohammadwazeri_0-1664292301376.png

 

Any help would be appreciated.

 

Thanks,

Mohammad

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

Hi , @Mohammadwazeri 

According to your description, you want to turn off the "Drill Up, Drill Down, and Next Level Hierarchy". Right?

You can see this tips in these configuration :

vyueyunzhmsft_0-1664331131884.png

When you close these settings , is just work in "Reading View" in  Powe BI Service . So you need to publish your report to your workspace in Power BI Service. Then in Reading View , you will not see the bnuttons you have closed.

vyueyunzhmsft_1-1664331226234.png

vyueyunzhmsft_2-1664331257518.png

 

Best Regards,

Aniya Zhang

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

4 REPLIES 4
v-yueyunzh-msft
Community Support
Community Support

Hi , @Mohammadwazeri 

According to your description, you want to turn off the "Drill Up, Drill Down, and Next Level Hierarchy". Right?

You can see this tips in these configuration :

vyueyunzhmsft_0-1664331131884.png

When you close these settings , is just work in "Reading View" in  Powe BI Service . So you need to publish your report to your workspace in Power BI Service. Then in Reading View , you will not see the bnuttons you have closed.

vyueyunzhmsft_1-1664331226234.png

vyueyunzhmsft_2-1664331257518.png

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

Thank you so much @v-yueyunzh-msft, it's worked.

memali
New Member

From calender/date hierarchy field use the Year only, or you can workaround and create a duplicate column and used that in the visual.

 

memali_1-1664293965265.png

 

 

Thanks

M. Ali

Thank you for replying!

 

I want to turn off those highlighted with yellow, and I want to keep the one in red square.

Mohammadwazeri_0-1664294555346.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.