Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I am looking to show a table with progression over time.
I have data in 2 seperate columns, first is when the data was initially loaded,
and second is when it was corrected.
Then there is a column for Pass/Fail to show if data is correct/wrong.
Screenshot below
In the Remaining, I would like to have the value of "Grand Total" less any data from "Updated Date",
so in this case would expect
Initial Load Date | Updated Date | Grand Total | Data With issues | Data without issues | Remaining |
05/07/2023 | 95 | 4 | 91 | 4 | |
05/07/2023 | 11/07/2023 | 100 | 1 | 4 | 5 |
09/09/2023 | 107 | 7 | 4 | ||
11/07/2023 | 109 | 2 | 4 |
Sample Data
C Number | Contact | Handler | Rating | In Link | FLAG | Initial Load Date | Updated Date |
1 | 546 | AVC | 1 | Yes | Pass | 05/07/2023 | |
2 | 547 | AVC | 2 | Yes | Pass | 05/07/2023 | |
44 | 589 | JQK | 6 | Yes | Fail | 05/07/2023 | |
30 | 575 | JQK | 33 | No | Fail | 05/07/2023 | 11/07/2023 |
31 | 576 | JQK | 1 | Yes | Pass | 05/07/2023 | |
32 | 577 | JQK | 2 | Yes | Pass | 05/07/2023 | |
33 | 578 | JQK | 3 | Yes | Pass | 05/07/2023 | |
34 | 579 | JQK | 1 | Yes | Pass | 05/07/2023 | 11/07/2023 |
54 | 599 | POL | 3 | Yes | Pass | 05/07/2023 | 11/07/2023 |
Please reformulate your request. It is not clear what you are trying to achieve. You mention that you want a time graph but your expected outcome is a table.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
97 | |
65 | |
45 | |
39 | |
31 |
User | Count |
---|---|
164 | |
111 | |
61 | |
53 | |
38 |