Forum Discussion

jeseng's avatar
jeseng
Icon for Helper III rankHelper III
3 years ago
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 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

Need Help

4 Replies

  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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's avatar
      jeseng
      Icon for Helper III rankHelper III
      3 years ago

      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's avatar
        ERD
        Icon for Community Champion rankCommunity Champion
        3 years ago

        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.