Drill Down on Matrix Wont Show When I Publish to Power BI Service

[Anonymous]

I have the below matrix with 3 levels of row drilling, PBU, Entity and Plant location.

It works fine in power bi desktop, but when I publish to Power BI Service, I can only see the second level of the drill down, and when I click the  + sign to see the thrid level, nothing happens.

Anyone have any idea why this may occur?

Mark Janecek

PTP Metrics Analyst

Johnson Controls

[huyentruong]

I have 6 levels. Everything works fine in PBI Desktop. But in PBI Service, drilling down from 5th level to 6th level does not work. Specifically, I click the plus sign, it turns into minus sign, but no drilling down happen.

[_GianmaBI46]

Hi,  I have the same issue. In my case it works in the Service Workspace but cannot expand in the published app.

[v-jayw-msft]

Hi @Anonymous ,

Did you enable the "New format pane"?

Best Regards,

Jay

[Anonymous]

I did and the drill down still shows - signs next to the second level of the hierarchy when I publish to the power bi service and exapand the entire level.

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

New format pane is still a preview feature.

This issue has been submitted internally.

Internal ICM ID: 278524684.

Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,

Jay

[vkkareer]

Any solution to this? I've facing the same issue in January 2023...

[Hiep_Nguyen]

likewise, 1/9/2024. + icon drills down in desktop but not in web once i publish (+ does nothing after second level drill down but still works in desktop copy as mentioned)

[usernameabc]

same issue in june 2024, the + button changes to - and does not show anything, while it works fine in the desktop

[pelink]

Is this issue solved? I have the same problem. After publishing the report, last level isn't showed up.

Before Published

After Publised

[Anonymous]

Hello @Anonymous 

 You will have to expand the matrix by clicking on "+" icon near "baltimore"

Did I answer your question? Mark my post as a solution!

[Anonymous]

That is the issue.  When I click the + sign, nothing happens.