Forum Discussion

Silver75's avatar
Silver75
Frequent Visitor
9 years ago

Survival Analysis with PowerBI and R

Hi I'm trying to realizing a Kaplan Mayer Survival non parametric model in PowerBI Desktop using script R, with filter in a drill-down I have a flat file/table in PowerBI with main information for ...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Silver75,

Your script is right as I tested. I run the sample script and get expected result.

I create a sample table.



Then click R visual highlighted in red line in the following screenshot. Select the Test[tenure] andTest[censor] as value levels.

 

Type the R script and run, you will get the desired result which is same with the picture in Rsudio.



If there is any error message when you run the scipt? Could you please share more details for further analysis.

Best Regards,
Angelia

Silver75's avatar
Silver75
Frequent Visitor
9 years ago

Hi v-huizhn-msft

thank you, any error during the script, the survival probability is overstimated respect other software, in particular KM cut some time intervals.

 

In add, If I insert in the dataset other variable (eg sex, civil status, etc..) the Drill – Down on survival graph doesn’t work

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi Silver75,

    Do you mind share your .pbix file for further analysis?

    Best Regards,
    Angelia