Forum Discussion
Do not Summarise Table Data
- 5 years ago
Hi, PBIMike
In advanced editor,you can try feature "Group by"
result1:
In Report view, you just need to change the sumarize type as below:
result2:
Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry, I don't understand. In the example I gave there are 7 unique customers but only 5 unique order numbers. Values in the visual summarise by order number, and only return the first customer result.
Example data:
Order/cust value
1 Cust A 10
1 Cust B 10
2 Cust C 10
3 Cust D 10
4 Cust E 10
5 Cust F 10
5 Cust G 10
Example visual result:
Order Customer Value
1 Customer A 20
2 Customer C 10
3 Customer D 10
4 Customer E 10
5 Customer F 20
I want the visual to show the detail available in the data, and not summarises repeated orders into a single row. Hopefully I've explained that a bit better but please let me know if it doesn't make sense.
Many thanks,
Mike
- v-easonf-msft5 years agoCommunity Support
Hi, PBIMike
In advanced editor,you can try feature "Group by"
result1:
In Report view, you just need to change the sumarize type as below:
result2:
Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.