Forum Discussion
Transactional Data Under Same Data Point - Visualization
Hello,
This should be a simple question but cannot figure it out for the life of me. Below I have an example of data I am looking at. Essentially, I want to be able to create a column chart that shows both 'In' and 'Out' transactions. The issue is that In and Out both live under Transaction. Any idea whether through DAX or Power Query Editor that I can split these out to achieve the chart?
Thanks!
You can use the Transaction field as it is to achieve this. Below, I entered data to a table to match your first 4 rows. I have the Date and Transaction fields in X-axis and a measure for the sum of Amount in Y-axis:
I would use a matrix, but yes. Here it is with Transaction as columns and Date in rows:
Here it is with Date in column and Transaction in rows:
Here it is with date and transaction in rows and nothing in column:
4 Replies
You can use the Transaction field as it is to achieve this. Below, I entered data to a table to match your first 4 rows. I have the Date and Transaction fields in X-axis and a measure for the sum of Amount in Y-axis:
I would use a matrix, but yes. Here it is with Transaction as columns and Date in rows:
Here it is with Date in column and Transaction in rows:
Here it is with date and transaction in rows and nothing in column: