Forum Discussion
Seeking Optimal Approach: Creating Visuals for Clustered Column Chart
I'm facing a challenge in creating a visual representation of the attached clustered column chart. Currently, I've managed to address this by generating multiple sheets in Excel, which I subsequently...
Maybe restructure your data so it's more like this:
| Loan | Value | LTV | LTV Interval | Reduction Type |
| 11 | 20 | 0.55 | 40%-60% | None |
| 11 | 20 * 0.9 | Calculated | Calculated | 10% |
| 11 | 20*0.85 | Calculated | Calculated | 15% |
| 11 | 20*0.75 | Calculated | Calculated | 25% |
| 5.5 | 15 | 0.37 | 20%-40% | None |
| 5.5 | 15*0.9 | Calculated | Calculated | 10% |
| 5.5 | 15*0.85 | Calculated | Calculated | 15% |
| 5.5 | 15*0.75 | Calculated | Calculated | 20% |
You could do this in Power Query by puling the same source multiple times & then appending them all together.
Im not sure that I follow what you are thinking... I need to calculated all the values with the same percentage, so that I can see what happens if all the values decreases with 10-15-25%. Hopefully you understand what I mean:) If you see my column chart you can see that I have 4 different bars with the original data and then the stressed values.