Forum Discussion
Need help to create a grouped bar chart over date
Hi ! I'm discovering Power BI and can't find a way to translate my excel graph to Power BI. I have a table with this kind of values Issue Number Created on Solved on Topic I240701 04/05/...
I just checked and it doesn't work for my requirement. Fields Solved on and Created on are always filled because my extraction comes from all the issues solved. I just have different dates.
| Issue Number | Created on | Solved on | Topic |
| I240701 | 04/05/2024 12:56:10 | 17/06/2024 10:11:58 | 03H |
| I240702 | 10/06/2024 16:24:03 | 17/06/2024 12:11:59 | 07V |
| I240702 | 10/06/2024 16:24:04 | 19/06/2024 13:11:55 | 07V |
| I240702 | 19/06/2024 15:24:03 | 19/06/2024 15:11:59 | 07V |
For example here I need to have :
| Issues created | Issues solved | |
| 04/05 | 1 | 0 |
| 05/05... 9/06 (each line for each day) | 0 | 0 |
| 10/06 | 2 | 0 |
| 11/06... 16/06 (each line for each day) | 0 | 0 |
| 17/06 | 0 | 2 |
| 18/06 | 0 | 0 |
| 19/06 | 1 | 2 |