How to calculate/visualize proportions in a scatter plot

[Anonymous]

So I am trying to better understand our knowledge article views. I would like to understand what % of articles represents what % of article views. In excel I manually created a scatter plot with a line which had % of articl views on the x axis and % of articles on the y axis. 

This helped to see that the top 10% of articles accounted for 80% of the views. I am trying to recreate a similar graph in powerBi and cannot figure out how to do it. Any help to create a similar map or a different visual that serves the same purpose of showing distribution of article views amongst the different articles??

Thanks for the help!

[v-danhe-msft]

Hi @Anonymous,

Could you please offer me some sample data to have a test and post your desired result if possible ?

Regards,

Daniel He

[Anonymous]

This picture is an example of what I am trying to do- if is not exactly like this that is fine, but I just need to see the proportion of articles compared to the proportion of views

[Anonymous]

Also ideally it would be great to be able to filter this graph by the date column and have it shift, but it is fine if I am not able to do that. Thanks for the help!!

[v-danhe-msft]

Hi @Anonymous,

Based on my test, I am afraid you could not achieve this feature due to the [of Articles%] and [of Viewers%] are both measures and you could not use the measures as Axis. 

Regards,

Daniel He

[Chihiro]

You mean something like Pareto analysis?

Check link below.

http://blog.blumshapiro.com/blog/2017/07/25/create-a-pareto-chart-in-power-bi/