Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
In the modelling tab I was able to change the default summaziration to don't summarize but this is still now working..
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
That is what I have it on but still it does not show both values.
All items in the table show "don't summarize"
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
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.
In the modelling tab I was able to change the default summaziration to don't summarize but this is still now working..
Can you click on the reverse triange icon instead?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |