Two slicers - one line graph?

[jeseng]

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 regular slicer and can set it to "multiple choices with Ctrl" but I dont what more than TWO values! I then tried using two differnt slicers with singular select but then the line graph ends up empty? Is it not possible to let the viewer choose only two values from slicers and show them in a line graph? 😞

Regards Jess

[ERD]

@jeseng , 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.

[jeseng]

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.

[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.

[parry2k · Accepted solution]

@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...