Variable Extension- pick function to change dimensions

Nolan — Sat, 16 Nov 2024 17:22:33 GMT

Good afternoon,

I currently have a sheet with 6 toggle buttons using the Variable Extension tool and pick functions. I am able to get all the measures, labels, and titles in this bar chart to change based on the selection, however I need one of the toggles to be a different dimension from the rest and I cannot seem to get it to work. Basically I need the first toggle to be [Product Family] and the next 5 to be [Product Description].

This is my current dimension expression:

=pick(vDashboard, [Product Family], [Product Description], [Product Description], [Product Description], [Product Description], [Product Description] )

The Variable, vDashboard=1

When I click the different toggle buttons the dimension continues to be [Product Family] for all of them.

Any suggestions?

Thanks in advance!

topic Variable Extension- pick function to change dimensions in App Development

Variable Extension- pick function to change dimensions