Seeking Optimal Approach: Creating Visuals for Clustered Column Chart

I realise, and am sorry, that this is a very delayed response, however:

Load your data into Power Query

Remove all columns except [Loan] and [Value]

Add a calculated column called New_Value with formula =[Value] * 1

Remove the [Value] column

Rename the [New_Value] column to [Value]

Add a calculated column called LTV, with formula =[Loan]/[Value]

Add a calculated column called LTV Interval, with formula = if [LTV] < 0.4 then "Under 40%" else if [LTV] < 0.6 then "40% - 60%" if [LTV] < 0.7 then "60% - 70%" if [LTV] < 0.85 then "70% to 85%" if [LTV] < 1 then "Under 85% to 100%" else "Over 100%"

Add a calculated column called "Reduction Type" with formula ="None"

Duplicate your query so you now have 4 identical copies (you should be able to right-click on the name of your query in the list on the left and choose 'duplicate')

Rename the 4 queries to "No reduction", "10% reduction", "15% reduction" and "25% reduction"

Edit your "10% reduction" query so the first calulated column is [Value] * 0.9 rather than [Value] * 1

Edit your "10% reduction" query so the last calulated column is ="10% Reduction" rather than ="None"

Edit your "15% reduction" query so the first calulated column is [Value] * 0.85 rather than [Value] * 1

Edit your "15% reduction" query so the last calulated column is ="15% Reduction" rather than ="None"

Edit your "25% reduction" query so the first calulated column is [Value] * 0.75 rather than [Value] * 1

Edit your "25% reduction" query so the last calulated column is ="25% Reduction" rather than ="None"

Use the 'append as new' option in the ribbon to stack the 4 queries you have so far on top of each other.  This is the data you'll be using; name it something appropriate.

Finally, you might want to right-click on each of the 4 other queries and disable data-load so they don't clutter things when you drop out of Power Query