Matrix visual

[TomerIwanir1]

Hi, I have a Matrix visual with 5 row levels coming from dim tables.
My values are 8 columns coming from 2 fact tables.
I’m getting a lot of completely blank rows that I don’t want to display.
I don’t see an option to remove empty rows in the visual, and I noticed that “Show items with no data” is not selected.

Any ideas how to remove the rows? thx

[v-tsaipranay]

Hi @TomerIwanir1 ,

Thank you for reaching out to the Microsoft Fabric Community Forum. Glad it got resolved and if any further help please reach out .

[TomerIwanir1 · Accepted solution]

Hi all, the problem is resolved

thx for the tips, I added my mistake a column which cused the empty rows, once removed it got fixed

[cengizhanarslan]

Power BI keeps a row in a Matrix if any row-header combination exists in the model. So you could you visual filters to filter any rows that is blank for each measure or create e measure as below and use it as a visual filter by setting it equal to 1.

Has Data =
VAR HasFact1 = NOT ISBLANK ( [Measure From Fact 1] )
VAR HasFact2 = NOT ISBLANK ( [Measure From Fact 2] )
RETURN
IF ( HasFact1 || HasFact2, 1, BLANK() )

[Kedar_Pande]

@TomerIwanir1 

Matrix → Filters pane → Each row field → Basic filtering → Uncheck "(Blank)"

Apply to all 5 row levels. Blank rows disappear.

[danextian]

Hi @TomerIwanir1 

It would be easier for us to help you if you provided a sample pbix (with confidential data removed). You can see you semantic model and data but we don't.

[FBergamaschi]

Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Alternatively, you can share your .pbix via some cloud service and paste the link here. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

Need help uploading data? click here

Want faster answers? click here

[AntoineW]

How do you done your relationship between tables ? 

This happens when multiple dimensions and fact tables create empty combinations.

Why do you want to remove empty rows ? Is it not relevant ? 

You could remove the column or if you only want to filter that has value, you could a DAX measure with condition IF() and NOBLANK() on column