Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 months ago
Solved

Matrix visual

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 months ago

    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's avatar
cengizhanarslan
Super User
7 months ago

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() )