Forum Discussion

JonNixon's avatar
JonNixon
New Member
10 years ago
Solved

Power BI Matrix missing data

I am new to PowerBi coming from Power Pivot and Power Query.  I am building a matrix tied to data in an Access database.  I seem to be missing data in the report but getting it in the data query.   ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    That sounds like some sort of contextual filter being applied in the report. Alternatively, with Power BI and matrices, if you do not have values for columns, it tends to drop those columns. For example, if you had a "Name" and 2 value columns, "Value1" and "Value2" like so:

     

    Name,Value1,Value2

    Thing1,10,10

    Thing2,,10

    Thing3,10,

     

    Thing1 will always show up whether you have Value1 and/or Value2 in your matrix, but Thing2 and Thing3 will only show up if you have Value2 or Value1 in your matrix respectively.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

That sounds like some sort of contextual filter being applied in the report. Alternatively, with Power BI and matrices, if you do not have values for columns, it tends to drop those columns. For example, if you had a "Name" and 2 value columns, "Value1" and "Value2" like so:

 

Name,Value1,Value2

Thing1,10,10

Thing2,,10

Thing3,10,

 

Thing1 will always show up whether you have Value1 and/or Value2 in your matrix, but Thing2 and Thing3 will only show up if you have Value2 or Value1 in your matrix respectively.