Forum Discussion
PBIMike
Helper III
5 years agoDo not Summarise Table Data
Hello, I currently have a list of orders, where, for reasons I won't explain here so as to confuse matters, many order numbers are repeated, eg. Order/cust value 1 Cust A ...
- 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.
amitchandak
Super User
5 years agoPBIMike , In all the visual tables same values will not repeat. So you have Add a customer or add an index column and use that is visual https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi