Expressions on x-axis in bar chart

[#1]

Hi,

I've tried searching the community, but couldn't find anything answering this question.  I think it's simple:  I have three expressions using set analysis for current MTD actuals, current month YTD actuals, and current month YTD forecast.  I'd like to have three such bars in a bar chart with these expressions in the x-axis, and display the bars stacked by region.  I can only get it to display in the reverse.  See the attached for this example.  Thanks in advance!!

Justin

[#2]

Justin,

One solution (not my favorite) is to create a synthetic dimension using the ValueList() function, and then in your expression use IF statements to figure out which calculation you should do.

For example:

Synthetic dimension:

ValueList('MTD Actuals', 'YTD Actuals', 'YTD Forecast')

Expression:

IF(ValueList('MTD Actuals', 'YTD Actuals', 'YTD Forecast') = 'MTD Actuals', <<MTD Actuals expression>>,

IF(ValueList('MTD Actuals', 'YTD Actuals', 'YTD Forecast') = 'YTD Actuals', <<YTD Actuals expression>>,

IF(ValueList('MTD Actuals', 'YTD Actuals', 'YTD Forecast') = 'YTD Forecast', <<YTD Forecast expression>>)))

Like I said, not my favorite... but it might be your only option.