Correct format of data for an Area Chart?

[Anonymous]

Hi all, I hope you are all safe and well.

Now, my brain won't work, and I can't figure out how to arrange my data to create a an area chart for a hardware roll-out we are doing.

So, as the technicians complete the swap-out of old kit for new, they are adding their name and the date in a spreadsheet that contains all the old kit that needs removing.  So I have a column of dates.  How do I format that so I can have an area chart showing how many are done on each date?

Thank you.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Group your dates to get a count of each date, then create the running total from the grouped count.

Sample PBIX here with dummy data

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

Thanks @PhilipTreacy  and @v-eqin-msft . However, neither solution addresses the first part of the issue. The data is just dates. Both solutions start with the dates counted up. 
You both have tables that will say | 27/10/2020 | 3 |
While I will have:-
27/10/2020

27/10/2020

27/10/2020

28/10/2020

28/10/2020

How can I seach the completed date column to count each date there?

Thanks in advance.

[v-eqin-msft]

Hi @Anonymous ,

According to my understand, you want to  use Line and stacked column chart to see the difference between the value per day and the sum value of the previous day, right?

You could use the following formula:

sumPrevious =
CALCULATE (
    SUM ( 'Table'[Number] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Date] <= MAX ( 'Table'[Date] ) )
)

My visualization looks like this:

Here is the pbix file.

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,
Eyelyn Qin

[PhilipTreacy]

Hi @Anonymous 

You've asked for an area chart but your image shows a column/line chart?

You also said Here is the graph I want from Excel. but you want this in PBI?

Without any of your data I've created my own to produce this

You can get the PBIX file here with the setup you can copy.

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Anonymous]

I cannot be any more specific about the dataset just being a column of dates next to each job when it is complete.

The dates column will serve as the X axis, while the Y axis needs to be a running total of the count of each date, so that today's total is added to yesterdays running total.

Here is the graph I want from Excel.

Due to COVID, we are falling far behind.

[vivran22]

Hello @Anonymous,

Can you share the sample data/pbix file along with the expected output as an example?

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter