two single select slicers for one graph

[Andi_R]

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!

[Anonymous · Accepted solution]

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.