Bar chart to show last 4 weeks count

[AlecS07]

Hi

Looking for some advice/help on getting a visual how I want it to display.
I currently have a datafeed from a CSV loaded in which shows a table list of items and a donut chart.

The table list consists of application names, created dates.

I'd like to show a bar chart to display the last 4 weeks and how many applications we have in total based on their dates.
For example, during April 2 new applications were added, 3 in March, several in Feb and a few in January.

How can I display a bar chart to show the increasing number of applications added per week?

Thankyou

Alec

[Housden996]

If you only want the past 4 weeks of data and no dynamic filtering you can jsut add the date field on as a filter and set this to relative date and then 4 calendar weeks or just 4 weeks.

[Tahreem24]

@AlecS07 , It would be great if you can share the sample input along with your expected result. So, based on your input columns we can help you out.

[Greg_Deckler]

@AlecS07 This might help. Better Running Total - Microsoft Fabric Community Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[AlecS07]

Hi Greg,

Sorry Let me explain a little bit more with some pictures.

This is the list of applications on the left which have dates when they were created. We have a total count at the top and what we would like to see for progress status is a bar chart which shows the last 4 weeks as dates along the bottom and then a count of applications based on their dates against the last 4 weeks to show how many new applications have been migrated per week. This data will be refreshed weekly and new applications will be added to the list / data.

If you require further info, please ask and I shall draw the bar chart.
Thankyou

Alec

[AlecS07]

@Greg_Deckler 
I can get a bar chart to show applications added within the last 4 months but what I would like is rather than showing new counts across the months, the total value increasing instead.

So example In Febuary we had 60 applications and then in March 4 more were added so the total for March would be 64  and then 12 more added in April so the total for April to be 76 if that makes sense?

[Greg_Deckler]

@AlecS07 Better Running Total - Microsoft Fabric Community