cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

How to turn off Drill Down option for rows in Matrix Visual

Hi Team. I have a scenario where I want to show the data with out Drill Down  in matrix visual. The requirement is Let's I have 2 rows , 1 column and 1 values in my Matrix table. Please find the below report for reference.Matrix.PNG

If you see I have taken 2 rows, By default those 2 rows were showing as Drill Down feature. But in my case I want to show both rows are like below visual. Meaning I want to show both the rows are like "Product ID", "Product Name" and remaing data in matrix visual like column data and values data should be same as above report. I just want to show rows are like table visual in matrix and Drill Down shouldn't be appear.

I have tried it many times but it seems like default behaviour. I hope someone will find the answer.

Could anyone help on this issue?

 

Table..PNG

 

 

Best Regards,

Srihari

 

11 REPLIES 11
Super User I
Super User I

@SrihariG , 

 

Under format pane Turn off both Stepped layout and +/- icons. So that you will get the below Matrix.

manikumar34_0-1603194912879.png

 

And then in Visual headers turn off Drill down options, so that end user cannot drill down. 

 

Regards, 

Manikumar

 





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




@manikumar34  Appreciate for your help. I have tried with the options which you have mentioned but the problem If I turned off Stepped layout and + icon it will only hide "+" icon and it is not showing of the 2nd row data which is "Product Name" then client will not be able to see the data of "Product name". But in my case I need to show the data of both rows.

 

Best Regards,

Srihari

@SrihariG , 

 

Before turning off those options Expand the Rows and then turn off. 

Forgot to mention last time. 

 

Regards, 

Manikumar

 

If you think this is helpful, Accept as a Solution and leave a like





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




@manikumar34 , Thanks for the solution. The solution which you have provided is almost working but there is some change in required output.  Please find the below output visual which I have got.MatrixsPNG.PNG

If you see the above report, Let's say If i have duplicate Products like "A","A","D","D" etc and it has respective data of remainng columns. If there is a Duplicate Product name then it should show like below report in matrix visual. here I am just giving the expected output in excel for reference.

 

Matrixoutput.PNG

 

Best Regards,

Srihari

 

 

@SrihariG , 

 

As per my knowledge we don't fill down the values with the headers on row. This is a limitation. 

 

Please check with this in forum if there is anyone who can help with this.

 

Regards, 

Manikumar





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




@manikumar34 

 

Thanks a lot for the help. Sure, I will check with this in forum.

 

Best Regards,

Srihari

@SrihariG ,

 

Sure 🙂

If you think this is helpful, Accept as Solution and Levae a like.

 

Regards, 

Manikumar





If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Super User II
Super User II

@SrihariG - Give a try by switching off stepped layout as below-

1.png

 

Appreciate your kudos!! Mark my post as solution if this helps.


Nikhil
Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!

@NikhilKumar , Appreciate for your help. I have tried the option which you have mentioned but the visual is same and it is not turning off Drill Down.

 

Best Regards,

Srihari

Super User IV
Super User IV

@SrihariG , In the format of visual property there are two-three options for drill, check if those can help

refer more option like stepped layout off at -https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

 

Drill Down Options.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandak, Thanks for your help. I have also tried with the same options but no luck and I am not getting the required output.

 

Best Regards,

Srihari

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors