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.
Hello,
I am currently creating a dashbaord to demonstrate the following indicators from our day to day operations:
- Incoming Requests (Volume received)
- # of transactions completed
- # of transactions outstanding
I am having issues since my Volume and Completed columns are not cumulative while my outstanding column is. So when I am making a graph, it makes the sum of the volume and completed column which is good but it also sum up the outstanding column while the values in this column are already a sum...
I would like to optimise the structure of my datasource, here is what it look likes right now.
Date | Type | Volume (New) | Completed (New) | Outstanding |
2021-04-15 | Credit | 500 | 0 | 500 |
2021-04-15 | Financial Rejects | 450 | 50 | 400 |
2021-04-15 | Non-Financial Rejects | 900 | 100 | 800 |
2021-04-15 | GD Mailbox | 15 | 10 | 5 |
2021-05-03 | Credit | 50 | 30 | 520 |
2021-05-03 | Financial Rejects | 50 | 100 | 350 |
2021-05-03 | Non-Financial Rejects | 100 | 200 | 700 |
2021-05-03 | GD Mailbox | 10 | 5 | 10 |
2021-05-17 | Credit | 50 | 100 | 470 |
2021-05-17 | Financial Rejects | 100 | 150 | 300 |
2021-05-17 | Non-Financial Rejects | 150 | 250 | 600 |
2021-05-17 | GD Mailbox | 2 | 2 | 10 |
Thank you very much in advance.
@Whoule
Which chart are you using? can you explain with your chart? Normally you should add type to legend to distinguish.
Paul Zheng _ Community Support Team
The issue is that I want to report on how much we completed vs the # of outstanding items as of a certain date. The data for my completed column seems fine in my chart since it sum up the values as of that date. The problem is that it also sum up my outstanding items from my data source...
@Whoule , can you share expected output
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |