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

     

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.