Forum Discussion

powerdev's avatar
powerdev
Regular Visitor
8 years ago

Creating a percentage graph

I am attempting to show a distribution of patient risk across a 1 - 100 scale. I can produce the following graph that shows deitentified patient ids and their total risk score.

 

 

What I would ultimately like to do with this data is create the following chart showing the total percentage on the x axis and the count of patients in each bucket.

 

 

I just cannot seem to figure out how to use accomplish this. It appears that a good use case for this is binning, but my final output is a calculated field and the option for a new group is not available. Any suggestions?

Need Help

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi powerdev,

     

    Aggree with the solution you mentioned that to use "Bin" to generate new group. But what do you mean "my final output is a calculated field and the option for a new group is not available"? After creating a bin based on a specific field, it will dynamically add a calculated column in table view, you just need to add this new field into X-axis of column chart.

     

    Regards,

    Yuliana Gu

    • powerdev's avatar
      powerdev
      Regular Visitor
      8 years ago

      Thanks v-yulgu-msft for the reply.

       

      What I mean is that the "Risk Score" column above is itself a calculated measure. When I select it and try to select "New Group" from the menu it is greyed out. I am thinking that creating a group from a calculated measure isn't possible. Is this correct?

  • powerdev's avatar
    powerdev
    Regular Visitor
    8 years ago

    Hmmm... I am not getting much feedback on this.

     

    Can anyone tell me if it is possible to take a result set (from a view) (calculated from several calculated measures) like the following:

     

     

    and turn it into a new table? I am sure that I could then use binning to achieve the visual that I need.

    • Vvelarde's avatar
      Vvelarde
      Icon for Community Champion rankCommunity Champion
      8 years ago

      powerdev

       

      Hi, If your BINs are 0 to 100 and Risk Score is a WholeNumber between 0 to 100. You can try with this:

       

      1. Create a Table with Bins:

       

      Modeling--New Table

       

      Bins = GENERATESERIES(0;100;1 )

      2. Create a CountofPatientID

       

      CountOfIds =
CALCULATE (
    COUNT ( Table2[PatientID] );
    FILTER ( Table2; [AVG Risk Score] = SELECTEDVALUE ( Bins[Value] ) )
)

      AVG Risk Score is your measure

       

      3. Insert a Visual:

       

      To select the colors you can work with Data Colors (But you need to assign to each bin the color )

       

      Let me know if works on your side

       

      Regards

       

      Victor

      Lima . Peru