Looking for a Week over week data report Line+stacked column chart

[beda2012]

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

[Anonymous]

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

[Rupak_bi]

Hi is this solve your purpose

[xifeng_L · Accepted solution]

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~