I'm trying to create a bar chart with 2 dimensions (expense type and year) and 2 measures (actual cost and budget cost). My goal is to display separate bars for actual cost and budget for each selected year for every expense type.
The standard chart doesn't support using 2 dimensions and 2 measures. Is there any trick I can use to achieve this?
But generally you want a calculated dimension that is just =Dim1 & ' - ' & Dim2. Note that you may need to use Aggr() depending on the scope.
In your scenario, it looks like you may want to flip around the measure/legend pairing and go with Year & Budget or Year & Actual, with a single measure that checks which kind it is and sums the appropriate field. You can then use the second (legend) dimension for Expense Type.
