Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
75 | |
71 | |
64 |
User | Count |
---|---|
140 | |
109 | |
103 | |
82 | |
73 |