Forum Discussion
Helper IIITwo slicers - one line graph?
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
Community Championjeseng , do you want to show 2 particular areas in the slicer or limit the amount of areas?
Your line graph is empty because the single value cannot be of several areas at the same time.
jesengHi,
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.- ERD
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.