Forum Discussion

milo's avatar
milo
Frequent Visitor
6 years ago
Solved

Matrix count showing same number for each column

Hello,

 

I made a matrix using a count of a field from my database. This is what it looks like:

 

Matrix

 

As you can see, each column has the same number for each row. I exported the data and made a pivot table to demonstrate what this matrix should look like: 

 

Pivot

 

 
 
 
 
 

Does anyone know how i can make the matrix match the pivot table values?

 

Thanks

Need Help

9 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi milo ,

     

    could you post a screenshot of the model view?

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

    • milo's avatar
      milo
      Frequent Visitor
      6 years ago

      Hello Marcus,

       

      I do not see a model view in my version of Power BI. I have added a screenshot of my relationship view:

       

       

      • mwegener's avatar
        mwegener
        Most Valuable Professional
        6 years ago
        Hi milo,
        as you can see in the screenshot, the service table (column) does not filter the manifest table (value).
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI milo,

    Current power bi only export records that visual used, it not able to keep the original visual style. Maybe you can use 'export as pdf' feature to save report pages and visual styles as pdf.

    Regards,

    Xiaoxin Sheng