Forum Discussion
Selecting appropriate visual for showing date difference
Hello,
I am reposting this for help. I have the following dataset and I would like to visualize in the best way possible.
| File Received | Audited | File Sent | Production Error | Manufacturer Error | Pending |
| 2023-07-11 | 2023-07-11 | 2023-07-11 | 0 | 0 | 0 |
| 2023-09-15 | 2023-09-15 | 2023-09-15 | 0 | 0 | 0 |
| 2023-11-03 | 2023-11-11 | 2023-11-11 | 0 | 2 | 3 |
| 2023-12-01 | 2023-12-01 | null | 0 | 0 | 0 |
Is it possible to show in "one line chart visual" when the file was recived, when it was audited and when it was sent? The idea behind is to measure how much time it took in the process, and how many errors were there.
Thanks
2 Replies
AbhinavJoshi , Create a date table, join all date with that. One join will active others inactive. You can activate join using userelationship
calculate(calculate(countrows('Fact'),userelationship('Date'[Date], 'Fact'[Received]))
refer for more detailsPower BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUHello amitchandak. Thanks for the advice and resources. However, the visual showed in the videos would not be helpful in this scenario. The video shows a great way to model the data but in my case I already have it. Do you have any visuals in mind that can compare three dates and their values (Excluding Table and Matrix Visual).
Thanks
