Forum Discussion

Gomaa72's avatar
Gomaa72
Regular Visitor
4 years ago

Duplicates not showing in Matrix visual

Hi ,

I created a Matrix visual where there is a column ( "SDW No." in viual and "submital No. " in query  )  having duplicte values related to anther column in the Matrix (rev) , in the query the duplicates are shown , but in visual doesn`t apper ðŸ¤”

I want these duplicate values to be shown in the visual .

 

Pls check attached images , you will see as an example  SDW-0001 repeated 2 times and SDW - 0002 repeated 4 times  in the query , while in the visual each are shown once only.

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Gomaa72 

     

    This is a behavior by design. In a matrix visual, the column field in Values area should always be aggregated. It means it only shows an aggregated result in the matrix. You can find the following description from official document Create matrix visualizations in Power BI 

     

    The matrix visual is similar to a table. A table supports two dimensions and the data is flat, meaning duplicate values are displayed and not aggregated. A matrix makes it easier to display data meaningfully across multiple dimensions -- it supports a stepped layout. The matrix automatically aggregates the data and enables you to drill down.

     

    If you want to show duplicate values, please use the table visual. Select Don't summarize for columns in the table. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.