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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Show next level arrow greyed out in matrix

Just today I realized that a lot of my reports are having a greyed out “show next level” drill down arrow on the top level of the hierarchy:

Eliasaki92_0-1684240097917.png


If I readd the columns to the row elements of the matrix it works again.
This appears to be a new bug and I am not sure if you aware of it.

Is this a known issue? @miguel1 

Status: Investigating
Comments
F2THEB
Frequent Visitor

I had the same issue and came here looking for a solution. Having found nothing I started to play around. 

Solution for me: and this is so stupid, but it did the trick: in the rows box on the visualizations tab, all I did was change the order of the fields. So for example Customer (upper level), Number (second level). I just swapped these. Right away the greyed-out double arrow became active.
Then I simply swapped the field (level) order again to the original one and the double arrow stayed active. 

That's it. 

This widget could not be displayed.