Selecting chart dimensions with a listbox

[markp201]

I  tried the cyclical but didn't care much for the interaction and thought of doing using a listbox

to select the dimension.  The measure is the same regardless but couldn't get it to work

correctly.  I figured the listbox would be simply "Store Product", "Product Group", "Store", etc.

I also tried DSE to return =[Store Product], [Store Product], etc but nothing would work.

I've seen the example enabling a preset dimension but that looked heavy on the maintenance.

Is there a simpler solution?

[sunny_talwar]

Have you looked here already?

Customizable Straight Table

[markp201]

Thanks for the link but what about =$('[' & [_Dimension] & ']') for the calculated dimension?

It doesn't work but seems like it should.

[sunny_talwar · Accepted solution]

You are missing an equal sign

$(='[' & [_Dimension] & ']')