Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
Hi, might want to look at the follwoing blog -
https://insurancedatainsights.blog/2024/02/16/insurance-triangles-in-power-bi/
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
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |