How to make Table show all values rather than grouping

[DSmith4]

Hi,

I have powerbi attached to SAP.

This brings in a list of documents.

These documents have:

1) document number

2) purchase order number

3) line on purchase order

4) dollar amount

Some times, there are 2 seperate postings in the same document, on the same purchase order, on the same line on purchase order, with the same amount.

SAP shows these as 2 seperate line items.

My powerBI table is showing this as a total amount.

How do I get powerBI to show the line items view for each amount rather than grouping amount?

Thanks

[Anonymous]

@DSmith4,

You can change dollar amount to Do Not Summarize instead, skip to Ways to Aggregate Your Data here in this link for reference:

https://docs.microsoft.com/en-us/power-bi/service-aggregates

[DSmith4]

That is what I have it on but still it does not show both values.

All items in the table show "don't summarize"

[Anonymous]

Try to remove it from your visual and drag it back in, or right click on your column under Fields pane, and select Don't Summarize

[DSmith4]

I deleted the field from the table and added back, no luck.

Tried to delete table and create a new one, still no luck.

I'm not sure if I'm doing it properly, but Im not able to chose

dont summarize from the fields pane.

[DSmith4 · Accepted solution]

In the modelling tab I was able to change the default summaziration to don't summarize but this is still now working..

[Anonymous]

Can you click on the reverse triange icon instead?