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 am facing the issue to show the data in the following format. As I am required to show the details sum ignoring the TOD date and Destination.
Currently I am getting the data in all the rows, its not grouping. I have tried the Matrix table too but its group left the data. The current output of my table visual looks like the below image.
Any way around to display the data in the above shared form?
Solved! Go to Solution.
Hi @pwc_ananta
If you want to show a sum value in only one row, you could remove delivery_date and dcpo(country) columns from the table visual. Or provide proper aggregation types for both. Do not select "Don't summarize" for both.
Best Regards,
Community Support Team _ Jing
@pwc_ananta , I doubt you can have a table/matrix like the one you have shown in image 1. Grouping is only possible for rows and columns, not for values
The image 1 is the output of Oracle XML Report. In which values are summed up on the basis of 5 columns. These duplication entries are occuring due to 2 drilled down columns that are delivery_date and dcpo(country).
Hi @pwc_ananta
If you want to show a sum value in only one row, you could remove delivery_date and dcpo(country) columns from the table visual. Or provide proper aggregation types for both. Do not select "Don't summarize" for both.
Best Regards,
Community Support Team _ Jing
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |