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
KatieH
Advocate IV
Advocate IV

Matrix Drilldown on Hierarchy

 Hi all,

 

In every matrix I have in every report, the drilldown does not appear to be working correctly.  I can click to turn on drilldown and can then select one of the items in the top hierarchy on my row but, as soon as I do that, the double arrow to "Go to next level of hierarchy" greys out and cannot be selected.

 

If I don't drill into the the rows, it will let me go through each level of the hierarchy as normal. Similarly, it will let me select the "Expand all down one level of the hierarch" button at any point.

 

I know that these have worked previously and I have not changed any of the data in the tables. I have even tried to build some more from scratch and end up with the same problem in the Desktop.

 

Has anybody come across this? Is there a way to resolve it?

3 REPLIES 3
rogeliodelacruz
Frequent Visitor

hello, can you solve the problem Katie?

v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @KatieH,

when you click to turn on drilldown and can then select one of the items, it is like an expand all the data for your item in this level, so you could not both turn on the Go to next level of hierarchy function, you could refer to below link:

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your reply Daniel,

 

This is something I was definitely able to do previously and is something I am still able to do if the data is set out on a graph.

 

Using a general date hierarchy as an example, if have a list of years then select the drill down to specifically look at 2017 for example, once I have selected that, I cannot now move down to the next level of the hierarchy to see all the months within 2017, I can only see the quarters. Even if I turn the drilldown button off at this point, it will not let me go to the next level.

 

However, if I change the exact same data set to a graph visual, this works with no problems.

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