Forum Discussion

ferrodalm's avatar
ferrodalm
New Member
8 years ago

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

  • 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-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi ferrodalm,

     

    What kind of result do you want? You can change the aggregation type of the values. Can you share a sample?

    Distribution_Graphic

     

     

    Best Regards,

    Dale

    • ferrodalm's avatar
      ferrodalm
      New 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