Forum Discussion

PaulRyan's avatar
PaulRyan
Frequent Visitor
6 years ago

Matrix using left outer join to display all data from one table and linked data from another.

Hello, new boy here. I hope this makes sense: I`m trying to create a matrix in my report which shows all item product groups down the side and all salesmen across the top (I`ve done this). I want t...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

PaulRyan it should work, if you share sample data, I can get you the solution. Put sample data in excel sheet and share thru one drive/google drive. 

  • 79775722's avatar
    79775722
    Regular Visitor
    4 years ago

    I have a similar need, but I want the matrix table to show both the parent side on the left and the many side columns on the right. 

     

    I want to apply filter on the many side to show certain records that meets the filter criteria. If not met, I still want to show the parent on the left side. Is this possible on the Matrix table visual side without changing the data model by applying filter at the PowerQuery ETL side? Thanks.

    • hmqc's avatar
      hmqc
      Regular Visitor
      3 years ago

      I have the same requirement, I need a Matrix Visualization with the principal table on the side and secundary table in the columns.

      • DE001's avatar
        DE001
        Frequent Visitor
        2 years ago

        I have the same requirement as well. Do we have solution for it? My matrix visual isn't showing the data for rows that are not in joined table. It only shows the data for rows in which both the tables have data for(Like an inner join).