Create a Switch to dynamically chance the AXIS or LEGEND of a chart

[gary_connolly]

I have created a table which holds the demographic variables used in various stacked bar charts.:

I was wondering if there was any way I could then use the SWITCH function to select the AXIS or Legend source, like I would for the measure:

X Measure = SWITCH(ALLSELECTED('Chart Measures'[Measure 1]),"Age", SELECTCOLUMNS(TransportCharge,[PatientAge]),"Ethnicity",SELECTCOLUMNS(Ethnicity,[EthnicCategory]),"Months",SELECTCOLUMNS(TransportCharge,[Transportation Month]),"Deprivation",SELECTCOLUMNS('Census Data',[Deprivation Group]))

[v-ljerr-msft]

Hi @gary_connolly,

Here is a similar thread in which some solutions are mentioned there. Could you go to check if it helps in your scenario? 

Regards

[GilbertQ]

What happens when you use your "X Measure"?