Scatter plot showing growth/decline

[winnston84]

HI,

I'm looking for some help to show the growth/decline in products (i.e. Phones, Laptops, Tablets, Desktop PC) between years e.g. 2013-2018. Essentially i am wanting a scatter graph showing:

• Size of bubble representing the total number of each category between the years
• Position on the chart vertically indicating the growth or decline of the product (i.e. laptops having 80% of total amount in 2013 and 5% in 2018 is in decline)

I have found this page https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter but am unable to follow it to make it work, as i am new to PowerBi. It has in the data something called "ScenarioID" and i have no idea what that is.

Any help would be greatly appreciated, apologies as i am sure this is very simple.

[dax]

Hi @winnston84 , 

I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[winnston84]

https://drive.google.com/open?id=1VQLviaaKEmLFcnWRmSvi8p0u_QRsMNqG

So i believe this is the calculation i am trying to achieve, the final column being the growth/decline of products over 5 years. From this I would hope would achieve a plot something like this:

https://drive.google.com/open?id=1h86ccJC9TF6SrfxBloTo426nXeev-Qjp

Fundamentally, i want a nice clear way to show which products are in growth and which ones are in decline.

[dax · Accepted solution]

Hi @winnston84 , 

I am not clear  about your data structure, I don't know the feature of  last several columns, if possible, could you please explain it to me in details. In addition, I use first 5 columns to create a report, you could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[winnston84]

Well the bit im struggling with is how to calculate the actual measure of if a product category is in growth or decline.

Between two years, i have found the calculation for that. However across say 5 years, i am not sure what the calculation is. I believe there is an excel formula called "LINEST" which will do it and provide a final 'score' which will be positive or negative - growth or decline. 

[parry2k]

@winnston84 it is pretty straight forward, see image below from the same link you mentioned in the post, you need to just add your measures and column in the respective section and you will get what you are looking for.

[winnston84]

Right thanks, that helps me understand what I need to do, but I am struggling to understand what measures I need for x and y