Forum Discussion
Solved
Two slicers - one line graph?
Hi, I developing a comparison page, where I want to compare two areas. I have a line graph and I want the user only to be able to choose TWO areas from a slicer (there are 36 in total). In a regul...
jeseng check this video on how you can achieve it Boost Your Power BI Skills: Comparing Values of Two Categories Made Easy | PeryTUS - Power BI How To - YouTube
Hi,
I want the user to only be able to select 2 values/areas. The idea is to compare two areas to each other, which two is up to the user, but MAX 2.
Well, you cannot limit the slicer itself, so you have to use some workaround.
One of them is to create a second table for the second slicer. And then you use the approach with two different slicers with singular select.
Another option is to use bookmarks that will show a message instead of a visual or above the visual if user selects more then 2 items in a slicer.