cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nripendrasinha
Regular Visitor

Drill down in Matrix Visualization

I am using Matrix Visualization in PowerBI report.

It has two step (level) drill down.

The drill down works fine in PowerBI Desktop however when I publish it to PowerBI service drill down wonly works for the 1st level.

The 2nd level doesn't open up or show when I click (+) sign adjacent to 1st level drill down.

Is there any limitation when using Matrix visualization

 

Also, I noticed that the double arrow showing "Go to next level of hierarchy" is inactive in App but it is active in Desktop.

 

Below is the picture of PowerBI report in app.It only open to 1st level

nripendrasinha_3-1611295246426.png

 

 

However, in PowerBI Desktop the drill down works fine.

 

nripendrasinha_2-1611295205025.png

1 ACCEPTED SOLUTION
vanessafvg
Super User I
Super User I

its quite a hard issue to understand without being able to interact with it.   Have you tried deleting the report in the service and republishing?





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

Proud to be a Super User!




View solution in original post

4 REPLIES 4
vanessafvg
Super User I
Super User I

its quite a hard issue to understand without being able to interact with it.   Have you tried deleting the report in the service and republishing?





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

Proud to be a Super User!




View solution in original post

I deleted the report and again published it...it works fine now :)...Thanks for the solution

vanessafvg
Super User I
Super User I

Ill be honest cant' really see the difference in the 2 pictures, did you navigate the hierarchy in exactly the same way and can you rather show the screenshots of when you have drilled down to the deepest level for each?





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

Proud to be a Super User!




Sorry, Now I post the screenshot of Desktop.

It can be seen that I can open to the deepest level 

 

nripendrasinha_0-1611295857618.png

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors