Forum Discussion
How to make a button slicer with multiple fields
Hello,
I'm trying to make a horizontal slicer which allows the user to select whether they want the dashboard to display variable 1 vs variable 2 (Ex: Sales of Apples vs Sales of Oranges). Whenever I try to add more than 1 field to my slicer, the orientation switches from horizontal to vertical, and the option dissappears. How would I create a button slicer that uses data from 2 seperate fields?
Note: I don't need to drill into the data for this dashboard. I just need it to display either all the data or none of the data, and both options can't be selected at the same time.
Thank you
4 Replies
- StefanoGrimaldi
Resident Rockstar
can you share a example of how you doing it and how you want it to be, for what you have described you should have a column that says witch sale type its if its in different table create a intermediate table connected to them via relantionships, and use that new table column as filter for sale type.
would need more information and example of your model for a better answer.
I'm basically trying to make something that looks like the below. I'm basically trying to make a button slicer based off column title values.
I've done this in the past where values from one field are the buttons but whenever I add the second field, it automatically reverts back to dropdown rather than list.
- StefanoGrimaldi
try making it in two different visual, one wil filter one level and the other another level to make that visual effect. (with 2 visual filter) maybe that could be a way.
