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

AntoineW's avatar
AntoineW
Super User
7 months ago

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