Forum Discussion
Seeking Optimal Approach: Creating Visuals for Clustered Column Chart
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.
Yes, so if your original table has 100 rows, then the table I'm proposing has 400 rows:
100 rows for no reduction
100 rows for 10%
100 rows for 15%
100 rows for 25%
All stacked vertically in one table
Then the values in your chart can just be SUM([Value]), legend is [Reduction Type] and x-axis is [LTV Interval].
Ok, now I understand! However my dataset consists of 200K rows and growing so it will soon be around 1 million rows... Will that be too large and not an optimal approach given the numbers of rows?