Forum Discussion

Andi_R's avatar
Andi_R
Frequent Visitor
2 years ago
Solved

two single select slicers for one graph

Hi everyone! Currently I'm trying to create a line chart that has two single select slicer inputs. Both slicers are based off of the same data sets that span over multiple months. I know that I could have them in a multiple select slicer, however based on how they are synced, the goal is to keep the single select. Even after having made sure that the slicers aren't interacting with each other, if two different data sets are chosen the graph shows up as blank. Is what I'm trying to do possible or do i need to switch how my slicers are synced? Thank you in advance for any advice or help!

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Andi_R ,

     

    Depend on your description, you should create below slicers table, then try formula like below to create measure:

    CombinedSales = 
VAR Selected1 = [SelectedValue1]
VAR Selected2 = [SelectedValue2]
RETURN
CALCULATE(
    SUM(SalesData[SalesAmount]),
    FILTER(
        SalesData,
        SalesData[Category] = Selected1 || SalesData[Category] = Selected2
    )
)

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Andi_R ,

     

    Depend on your description, you should create below slicers table, then try formula like below to create measure:

    CombinedSales = 
VAR Selected1 = [SelectedValue1]
VAR Selected2 = [SelectedValue2]
RETURN
CALCULATE(
    SUM(SalesData[SalesAmount]),
    FILTER(
        SalesData,
        SalesData[Category] = Selected1 || SalesData[Category] = Selected2
    )
)

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.