CODEWITHSUNDEEP
matrixpowerbi
Luis Ramon Ramirez Rodriguez
Luis Ramon Ramirez Rodriguez

Reputation: 10403

How to fix the size of the tables on power BI

I'm working with some data on a power BI matrix since it allows more dimensions than regular tables. The issue I'm having is that the size of the matrix changes depending on the filters I use.

E.G If I use no filters the matrix have 3 columns and 4 rows:

enter image description here

But if I select one the filters then I lose one row:

enter image description here

How Can I fix the size of the matrix and just show empty values if that's the case?

EDIT:

I have uploaded the data I'm using to google drive, it's just few rows:

https://drive.google.com/file/d/1_Jqer6ObhpA4OpxY8ymXunMiL4hg4tO8/view?usp=sharing

I'm almost taking the data as it is in the table except for the aggregation function for which I'm using this:

%Count = 
    DIVIDE(
        COUNT(Hoja1[score]);
        CALCULATE(COUNT(Hoja1[score]); ALL(Hoja1[score]))
    )

EDIT2:

I have added the new table:

enter image description here

And created the relation:

enter image description here

But still having the same issue:

enter image description here

Am I missing something?

Upvotes: 2

Views: 7018

Answers (1)

RADO
RADO

Reputation: 8148

Go to Vizualizations pane. In rows, where you have "score", click on a triangle. In a menu that pops up, check "Show items with no data".

enter image description here

Upvotes: 1

Related Questions