Forum Discussion
Seeking Optimal Approach: Creating Visuals for Clustered Column Chart
Is there anything stopping you having all the columns in the same table. i.e. you have one table with the following columns:
Loan
Value
LTV
LTV Interval
Value (10% reduction)
LTV (10% reduction)
LTV Interval (10% reduction)
Value (15% reduction)
LTV (15% reduction)
LTV Interval (15% reduction)
Value (25% reduction)
LTV (25% reduction)
LTV Interval (25% reduction)
At the very least this would keep everything on one Excel sheet. Even better, you could then have all the calculated columns set up as steps in the Power Query instead, so you're not calculating anything extra in Excel.
Hi
You're right and I have tried this. The problem occurs when I then want to present this as a visual like the clustered column chart which is based on the loan value. I have thought about making 3 equal loan value columns which are somehow linked to the different LTV Intervall columns, but I still dont have it completely figured out. I also tried so make som measures but then problem was that the measure only calculated on the total and then I got one answer for the whole dataset... So Im still searching for the best solution.