Creating a percentage graph

[powerdev]

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?

[powerdev]

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]

@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

[v-yulgu-msft]

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]

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?