cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DSmith4 Regular Visitor
Regular Visitor

How to make Table show all values rather than grouping

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

1 ACCEPTED SOLUTION

Accepted Solutions
DSmith4 Regular Visitor
Regular Visitor

Re: How to make Table show all values rather than grouping

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

6 REPLIES 6
NickNg278 Senior Member
Senior Member

Re: How to make Table show all values rather than grouping

@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 Regular Visitor
Regular Visitor

Re: How to make Table show all values rather than grouping

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

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

NickNg278 Senior Member
Senior Member

Re: How to make Table show all values rather than grouping

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 Regular Visitor
Regular Visitor

Re: How to make Table show all values rather than grouping

I deleted the field from the table and added back, no luck.2019-05-23_14-02-44.png

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 Regular Visitor
Regular Visitor

Re: How to make Table show all values rather than grouping

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

NickNg278 Senior Member
Senior Member

Re: How to make Table show all values rather than grouping

Capture.PNG

Can you click on the reverse triange icon instead?