Forum Discussion
Insurance progression triangle inversion
Dear powerbi team,
I have a data as shown below
after pivoting the data in excel i used to get progression triangle as shown below and i could able to get the generate the same progression triangle in powerbi
But i want to generate a progression triangle in powerbi as shown below.
in excel we used select the blank spaces and shift the cell's to left to get the progression triangle as shown above but i couldn't able to geerate the same in powerbi.
Requesting powerbi team to help me out with this.
Thanks in advance !
Baji_Komara review the attached file and tell me if this is your desired result
4 Replies
- DimaMDSolution Sage
Hi, Baji_Komara can you provide dummy data?
- Baji_KomaraFrequent Visitor
hi DimaMD ,
Here is the sample/dummy data.
MONTH Cust_ID April-22 till date may-22 till date June-22 till date July-22 till date August-22 till date September-22 till date 30-Apr-22 MOT12084051 304500 304500 304500 304500 0 4000 30-Apr-22 MOT12120845 1454500 1454500 1454500 1454500 0 2750 30-Apr-22 MOT12155495 604500 604500 604500 604500 0 4000 30-Apr-22 MOT12117989 2304500 2304500 2304500 2304500 2304500 4000 30-Apr-22 MOT12131817 604500 604500 604500 604500 604500 4000 31-May-22 MOT12183761 454500 454500 454500 0 4000 31-May-22 MOT12194840 574500 574500 574500 0 4000 31-May-22 MOT12196512 104500 104500 104500 0 3300 31-May-22 MOT12284788 329500 329500 329500 0 4000 31-May-22 MOT12286620 650500 650500 650500 0 4000 30-Jun-22 MOT12305440 374500 374500 0 4000 30-Jun-22 MOT12346170 504500 504500 4000 9800 30-Jun-22 MOT12310739 669500 669500 669500 0 30-Jun-22 MOT12312064 114500 114500 114500 0 30-Jun-22 MOT12319534 99500 99500 98300 3300 31-Jul-22 MOT12418992 404500 4000 9800 31-Jul-22 MOT12492118 459500 0 3300 31-Jul-22 MOT12532128 584000 0 4000 31-Jul-22 MOT12439877 219757 219757 3300 31-Jul-22 MOT12446627 122300 122300 3300 31-Aug-22 MOT12556880 0 4000 31-Aug-22 MOT12565342 0 3300 31-Aug-22 MOT12592283 0 4000 31-Aug-22 MOT12616965 0 4000 31-Aug-22 MOT12591062 109950 3300 30-Sep-22 MOT12660972 0 30-Sep-22 MOT12661016 0 30-Sep-22 MOT12667045 0 30-Sep-22 MOT12671195 0 30-Sep-22 MOT12672810 0 - DimaMDSolution Sage
Baji_Komara review the attached file and tell me if this is your desired result