Visualizing a Trend Based on Previous Versions of the Same Source

[naddger]

Is there a way to diplay the trend of monthly changing data, incrementally adding a snapshot of a given month's values to as a value to the column chart.

e.G:

Let's say that I load and visualize this in a simple column chart

Apple Count	Pear count
4	5

Next month (let's say Feb-18), my source will update and the counted values will change.

Apple Count	Pear count
3	4

Is there a way to reflect that change every month (scheduled) or when I update the source and incrementally add a column for the Apples (or 2 columns for both apples and pears) every month?

I could copy and merge them as two different tables into one like this

and generate the chart I want

	Jan-18	Feb-18
Apple Count	4	3
Pear count	5	4

But I'd like ot know, if there is an automated and easier mothod do do that.

I hope that makes sense.

[v-jiascu-msft]

Hi @naddger,

Can you share a dummy sample please?

What's the data source like? If new data is added (rows), the visual will be updated automatically. For example, the visual could be:

Date (Month)  Apple    Pear

Jan-18               4           5

Feb-18              3           4

Mar-18             8           9  (when the new data is added)

Best Regards,

Dale

[naddger]

Hi @v-jiascu-msft,

Think of the data as an inventory of assets that changes all the time.

What I am trying to achieve is snapshots of the same source (same structure in terms of columns), that has records that are either added, removed or modified.

So I want to compare the snapshots of the state of that data at the beginning of every month and add them to a chart.

I was thinking about adding a new table for every monthly update with a column, that contains the month name, thus getting a bar with counts of the assets for every month, but I don't know how to automate that and avid the multiple manual actions that requires.

So the column I want to visualize is 'Assets' (that are counted) and add the state of that column on the first day of every month.

[naddger]

Is there a way to diplay the trend of monthly changing data

e.G:

Let's say that I load and visualize this in a simple column chart

Apple Count	Pear count
4	5

Next month (let's say Feb-18), my source will update and the counts will change.

Apple Count	Pear count
3	4

Is there a way to reflect that change every month (scheduled) or when I update the source and incrementally add a column for the Apples (or 2 columns for both apples and pears) every month?

I could copy and merge them as two different tables into one like this

and generate the chart I want

	Jan-18	Feb-18
Apple Count	4	3
Pear count	5	4

But I'd like ot kno if there is an automated and easier mothod do do that.

I hope that makes sense.