Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Remove empty row headers from matrix

Dear PowerBI experts,


I hope one of you has a solution to the following. 


I am building a P&L report. The rows are derived from a multi-level account hiearchy where level 1 is the highest level. Lower levels are not always populated, apart from the (GL) AccountName where I also have the values from. Is there any way to hide the empty account levels from being shown in the matrix row headers?


My data model looks as following


Table: AccountStructure







Table: Facts






Rows: AccountLevel1, AccountLevel2, ...,AccountName

Value: Value


To make it visual, in the following example, I would like to remoce the +/- icon from Total gross Profit:






Not applicable


There is an excellent video here: that shows how to handle displaying hierarchical data in the context of a P&L statement.  The part that specifically addresses your issue is at 40:00 minutes, but you will likely need to watch the entire video for context.


NOTE:  Refer to Matt's website at where he provides the DAX formulas, which are slightly different than exactly what he used in the video, and worked better for my application.

Community Support
Community Support

Hi @sandeo 


The hiearchy columns have relationships with each other as the lower level is in the scope of its higher level. When a higher level is hidden, its lower level rows will be hidden too. Based on my test, I couldn't find a solution or workaround to this requirement currently.


Community Support Team _ Jing

Community Champion
Community Champion

@sandeo you can put a fiter against your values like below which will show only values greater than o so blank value column/row header will not appear




and to remove +/- icon, under the row headers section, please off the below selection




thanks. let me know if you are able to resolve your issue.

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

Proud to be a Super User!

Follow me on linkedin

Thank you for your rpely.


In my example, the values are actually not blank or 0. It is the row header that is blank. Unfortunately, enabling the filter on either the AccountLevel3 or Value to filter out zeros and blanks does not make a change.


Update: Adding a filter on AccountLevel3 to filter out empty records hides the whole row completely including the higher level, but that is not what I want...

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

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

Top Solution Authors
Top Kudoed Authors