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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dcrow5378
Helper II
Helper II

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.