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 wo...
Need Help
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
    Community 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