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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
dcrow5378
Helper III
Helper III

Hiding Drill option or removing values from specific Matrix row

Is there a way to hide a specific row from a matrix?

From the image below, I would like to be able to hide/zero out the child rows of Wages for Home Office Department while retaining the rolled up value.  I would like to be able to expand all of the other Parent/Children rows normally.  Any ideas?

 

dcrow5378_1-1663361855791.png

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

You would have to remove that level of detail in your source data.  It will still show as BLANK() though.  Ragged hierarchies are not supported in the matrix visual.

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

You would have to remove that level of detail in your source data.  It will still show as BLANK() though.  Ragged hierarchies are not supported in the matrix visual.

Thanks.  Are there any other visuals that will support this option? 

So basically would need to use a SWITCH (or some other function) in Query Editor?

This one supports ragged hierarchies

lbendlin_0-1663604381516.png

Warning - it will be very slow with anything above 10K granularity in the levels.  Understandably so as it needs to traverse the whole tree to decide what to show and what to hide.

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors