I have a bar chart with the option to select between multiple alternative measures and dimensions.
I want to change the chart name based on the measure and dimension I select. Is it possible?
Yes , it is possible but not with Alternative measures; instead :
1) create an inline table as follow:
load * inline [
2) add this newly created Dimension field as a filter pane in ur sheet
3) change ur dimension in your chart, from al-ternative dimensions to:
if(DimID=1, YourFirstDimension, YourSecondDimension)
with that, based on the selections u make in the Dimension field, one of your Actual dimensions will be the shown one in your chart.
4) In the title, :
'Measure by '&Dimension
The same logic can be replicated with your Alternative Measures.