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

Can you hide a drill-down row in a matrix

Hello,

 

I am trying to hide rows in a matrix and need help doing so. The purpose for that is the end-user wants to export the data into a spreadsheet and filter by the rows (in red rectangle below) but when accessing the matrix in power BI, they want to minimize number of clicks when drilling down by hiding the numbers.

 

Capture.PNG

 

It's improtant to note that I want to keep these 'rows' in my matrix, but hide the following (in red):

Capture.PNG

 

How can one hide rows within the matrix VISUALIZATION, but when exporting data to CSV, keep the 'Tax account no' and 'Client account no'?

8 REPLIES 8
YJ Regular Visitor
Regular Visitor

Re: Can you hide a drill-down row in a matrix

Hi, i am just thinking loud for this, but why not you have a seperate page report, one for download and another for your visuals. Both can be link to the same slicer.

 

Not the neatest but probably a quick and practical sol.

regards

 

danieljkim17 Regular Visitor
Regular Visitor

Re: Can you hide a drill-down row in a matrix

I see where you're going with this alternative solution, but it should be within the same matrix.

Icey New Contributor
New Contributor

Re: Can you hide a drill-down row in a matrix

Hi @danieljkim17 ,

Based on my knowledge, it is not supported in Power BI now. You can create a new idea here.

One workaround, you can use Hierarchical Variance Table - xViz instead. And put the columns you want to hide in Tooltip.

hierarchy.PNG

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

danieljkim17 Regular Visitor
Regular Visitor

Re: Can you hide a drill-down row in a matrix

 

 

Hello,

 

Thank you for the suggestion. I tried the Hierarchy Variance Table by importing to my power BI file, but I still see the rows.

 

In red below, you will see in the ToolTip I added Client Account No. THat is the row I would like to hide.

 

Capture.PNG

Icey New Contributor
New Contributor

Re: Can you hide a drill-down row in a matrix

Hi @danieljkim17 ,

"Client Account No." doesn't need to be put in "Category" field. Just put it in "Tooltip" and when you export data of this visual, the data of "Client Account No." is also there.

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey New Contributor
New Contributor

Re: Can you hide a drill-down row in a matrix

Hi @danieljkim17 ,


Is this problem solved?


If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.


If not, please let me know.


Best Regards
Icey

danieljkim17 Regular Visitor
Regular Visitor

Re: Can you hide a drill-down row in a matrix

Hello icey,

 

This problem has been resolved. It seems that the capability to hide certain rows is not supported by Microsoft just yet.

Icey New Contributor
New Contributor

Re: Can you hide a drill-down row in a matrix

Hi @danieljkim17 ,

Glad to hear that. Please accept your solution above so that people who may have the same question can get the solution directly.

 

Best Regards,

Icey

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 330 members 2,980 guests