Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!