Forum Discussion

PowerPaddy's avatar
PowerPaddy
Frequent Visitor
9 years ago
Solved

Insurance - Loss Triangles

Hi,
I was wondering if anyone has had any success in creating insurance Loss triangles in PowerBi? A typical claims loss triangle would show how losses develop over time for each period they were written in. eg...

 

 

Easy enough to create in Excel but I'm struggling in PowerBI and I can't find any custom visualisations.

Any advice greatly appreaciated, thanks

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi PowerPaddy,

     

    It is possible to create triangular matrix visual in power, you can refer to below sample to achieve your requirement.

     

    Prerequisite: matrix preview visual, two table without relationship.

     

    Measure:

    Measure = 
var current_Row=MAX('Row'[Row])
var current_Column=MAX('Column'[Column])
return
if(current_Row+current_Column<=13,current_Row*current_Column)

     

     

     

    Regards,

    Xiaoxin Sheng

3 Replies