Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Hi @Anonymous,
Could you please offer me some sample data to have a test and post your desired result if possible ?
Regards,
Daniel He
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
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!!
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
You mean something like Pareto analysis?
Check link below.
http://blog.blumshapiro.com/blog/2017/07/25/create-a-pareto-chart-in-power-bi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |