One button for multiple bookmarks option

[chenko90]

Hi all,

I have a visualization where I am looking at Revenue and Volume charts for year 2023,2022,and 2021. I would like a way where i can have a button to select revenue and then select any of the three years to see those specific charts. 

I am having trouble finding a simple way to make the year buttons work for both revenue and volume. I seem to only be able to set it up to work with one or the other. I am using bookmarks to build the views i want and mapping the buttons to those booksmarks. 

So my current problem is if I have revenue button selected and then i press 2023 it will go to revenue but if i press volume button it will still show revenue as that is where i mapped the 2023 button.... 

Hope this makes senese. Any help is much appreciated. 

[christinepayton]

I don't think I quite understand what you mean, but have you looked into using field paramters instead of bookmarks? Bookmarks will save every visual config you have by default; you can limit it to specific visuals in the bookmark settings but it tends to be "views" like you said, whereas field paramters are more about looking at your data dynamically in different ways.

[chenko90]

So something like this is what i want. I have the buttons as seen and i can select revenue and 2023 and it will show me that in the charts below, or i can select volume 2023 and it will show me that. My problem is I can't map the year to both revenue and volume button. I don't think parameters would work for me as each revenue and volume metric is a seperate column in my data. 

[christinepayton]

Naw, that's totally what field parameters are for. The slicer on the left would be a field parameter reference, the one on the right would be a standard horizontal slicer with your year column in it - no bookmarks needed. You would create two measures, one for revenue one for volume, add them to a field param, then drop the field param in the X-axis on the charts. I did a video on this a ways back if that helps at all (in the example we do sales amount and quantity, very similar concept): https://youtu.be/Nt3QgZrJXfY?si=0aJ4N5Q0EniRmMRQ