Forum Discussion
One button for multiple bookmarks option
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.
Most Valuable ProfessionalNaw, 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