Forum Discussion
Detail transaction with total
Hi FrankLaMa ,
Depending on the visual you're using, you can change the field color to something that blends with the visual's background (e.g. white on white). You can also rename the index column to a shorter one. For tables, that shuld be under Specific column tile in Visual tab under Formal visual pane.
Super UserHi FrankLaMa,
Do you have another column in your data that will make your table show each transaction line - some kind of an ID that is unique to each row? If there's none, my approach would be to add an index column in Power Query and use that in your visual so each row in the dataset is represented by an index number. For your reference: https://docs.microsoft.com/en-us/power-query/add-index-column
danextian Unfortunately, I don't have any ID to make it unique. However, I could use the solution you recommended to create a unique key. Is there way to hide that column in the visual since it will not make any sense to the users of the report?
- danextian
Hi FrankLaMa ,
Depending on the visual you're using, you can change the field color to something that blends with the visual's background (e.g. white on white). You can also rename the index column to a shorter one. For tables, that shuld be under Specific column tile in Visual tab under Formal visual pane.