Forum Discussion
Looking for a Week over week data report Line+stacked column chart
Hi ,
I am looking for a way to represent a trend line+ stacked column chart ( week over week) but i dont find a way to do it , can sm1 help , attaching a sample excel file for reference.
The ask is to show :
1- Bug ( issue type=bug) "created" Week on Week by the field "Priority"
2- Bug (issue type =bug) "resolved" week on week by the field "Priority"
3- A cummulative "Bug" trend Week on week by the field "Priority"
| Issue Type | Custom field (Application) | Updated | Status | Priority | Created | Resolved |
| Bug | BC | 5/29/2024 14:41 | Open | Medium | 5/29/2024 12:45 | |
| Bug | BC | 5/29/2024 12:24 | Open | Medium | 5/29/2024 12:06 | |
| Bug | PC | 5/29/2024 9:38 | Open | Low | 5/28/2024 9:36 | |
| New Feature | SC | 5/29/2024 9:05 | Open | Medium | 5/21/2024 9:05 | |
| Bug | PC | 5/29/2024 9:31 | Open | Low | 5/29/2024 6:17 | |
| Bug | PC | 5/28/2024 12:47 | Open | Highest | 5/28/2024 12:47 | |
| Bug | BC | 5/24/2024 13:27 | Open | Medium | 5/24/2024 13:27 | |
| Bug | DH | 5/28/2024 8:19 | Open | High | 5/20/2024 11:36 | |
| Bug | DH | 5/24/2024 4:35 | Open | Medium | 5/24/2024 4:34 | |
| Bug | CN | 5/27/2024 10:19 | Done | High | 5/19/2024 10:29 | 5/27/2024 10:19 |
| Bug | DH | 5/29/2024 11:54 | Done | High | 5/23/2024 9:53 | 5/29/2024 11:54 |
| Bug | DH | 5/28/2024 7:55 | Done | High | 5/23/2024 9:48 | 5/28/2024 7:55 |
| Bug | PC | 5/23/2024 14:18 | Open | High | 5/23/2024 8:19 | |
| Bug | PC | 5/23/2024 10:28 | Open | Medium | 5/22/2024 12:52 | |
| New Feature | FH | 5/23/2024 8:28 | Open | Medium | 5/22/2024 11:44 | |
| Bug | CN | 5/22/2024 11:42 | Open | Medium | 5/22/2024 11:42 |
Hi beda2012
One chart cannot contain all the information, that can be expressed in more than one chart.
I created a demo and you can refer to, hope it help.
Demo - Looking for a Week over week data report Line+stacked column chart.pbix
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
3 Replies
- xifeng_L
Super User
Hi beda2012
One chart cannot contain all the information, that can be expressed in more than one chart.
I created a demo and you can refer to, hope it help.
Demo - Looking for a Week over week data report Line+stacked column chart.pbix
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
- Rupak_bi
Hi is this solve your purpose
Hi beda2012 ,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
