Forum Discussion
Distribution Graphic
Hello,
I need to graph a 3 series's distribution have within a range of values from 1 to 10.
In the database I have more than 1000 records in series 1, and less than 300 in series 2 and 3.
When I graphic the data, the line of the series one takes values upper than the series 2 and 3, but I want to compare the proportionality indistinctly of the number of records for each value that the series has.
Is this possible with powerbi? or first I must generate the tables with the percentages per series so that I simply graph them.
Thank you
3 Replies
- ferrodalmNew Member
Hello,
I need to graph a 3 series's distribution have within a range of values from 1 to 10.
In the database I have more than 1000 records in series 1, and less than 300 in series 2 and 3.
When I graphic the data, the line of the series one takes values upper than the series 2 and 3, but I want to compare the proportionality indistinctly of the number of records for each value that the series has.
Is this possible with powerbi? or first I must generate the tables with the percentages per series so that I simply graph them.
Thank you
- v-jiascu-msftMicrosoft Employee
Hi ferrodalm,
What kind of result do you want? You can change the aggregation type of the values. Can you share a sample?
Best Regards,
Dale
- ferrodalmNew Member
Hi Dale v-jiascu-msft,
The problems is that I have 2 populations. For example.
Serie 1.- 20 articles from 100 have value 1, so is the 20%.
Serie 2.- 2 articles from 10 have value 1, so is the 20% too.
How do I do so that both points are plotted in the same space, without needing to first calculate the percentage they represent? or do I have to generate an extra table with the calculations and on it align the chart?
Example
Best regards,
Fernando