cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

## Multiple Slicers of same type in one graph

I want to insert two date slicers in one bar graph having two bars representing the total sales, each slicer will be used to filter one bar of total sales,so that i can compare total sales of two time period in one graph.

1 ACCEPTED SOLUTION
Community Support

Hi @Thalbish ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.Create two tables with slicer fields for the two slicers.

3.Drag the Date into the slicer 1 visual and drag the Date into slicer 2 visual.

4.Create two measures for the two slicers.

``````TotalSales1 =
VAR start_date = MIN('Table slicer1'[Date])
VAR end_date = MAX('Table slicer1'[Date])
RETURN
CALCULATE(SUM('Table'[Sales]), FILTER('Table', [Date] >= start_date && [Date] <= end_date))

``````
``````TotalSales2 =
VAR start_date = MIN('Table slicer2'[Date])
VAR end_date = MAX('Table slicer2'[Date])
RETURN
CALCULATE(SUM('Table'[Sales]), FILTER('Table', [Date] >= start_date && [Date] <= end_date))

``````

5.Create the Field table.

6.Create a measure to show a different measure.

``````Measure =
SWITCH(
TRUE(),
SELECTEDVALUE(Field[Sales Fields]) = "Sales 1", [TotalSales1],
SELECTEDVALUE(Field[Sales Fields]) = "Sales 2", [TotalSales2]
)``````

7.Select the bar chart, add the sales field into the Y-axis, drag the measure into the X-axis.

8.The result is shown below.

Best Regards,

Wisdom Wu

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

4 REPLIES 4
Community Support

Hi @Thalbish ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.Create two tables with slicer fields for the two slicers.

3.Drag the Date into the slicer 1 visual and drag the Date into slicer 2 visual.

4.Create two measures for the two slicers.

``````TotalSales1 =
VAR start_date = MIN('Table slicer1'[Date])
VAR end_date = MAX('Table slicer1'[Date])
RETURN
CALCULATE(SUM('Table'[Sales]), FILTER('Table', [Date] >= start_date && [Date] <= end_date))

``````
``````TotalSales2 =
VAR start_date = MIN('Table slicer2'[Date])
VAR end_date = MAX('Table slicer2'[Date])
RETURN
CALCULATE(SUM('Table'[Sales]), FILTER('Table', [Date] >= start_date && [Date] <= end_date))

``````

5.Create the Field table.

6.Create a measure to show a different measure.

``````Measure =
SWITCH(
TRUE(),
SELECTEDVALUE(Field[Sales Fields]) = "Sales 1", [TotalSales1],
SELECTEDVALUE(Field[Sales Fields]) = "Sales 2", [TotalSales2]
)``````

7.Select the bar chart, add the sales field into the Y-axis, drag the measure into the X-axis.

8.The result is shown below.

Best Regards,

Wisdom Wu

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

Frequent Visitor

Also can you please help me with applying this 2 date into a clustered bar graph which represent order type,i want one colour to represent the first date and another to other date as you have explained for salesAs you see in the above example i want one bar two represent delivery another with dine in and another with drive through, the clustered bar, ie;Orange and blue acts like when i set slicer for one date orange adjusts and other slicer adjusts blue,i also wanted to integrate this with our already created slicers

Super User

Hi! When you say two time periods are you wanting two random, unrelated time periods (i.e. maybe your user wants to compare sept and october to june and july) or are you wanting to do time intelligence (i.e. if the user selects January and February of 2024, you are comparing to Jan and Feb of 2023)?

Proud to be a Super User!

Frequent Visitor

Yes, I want two random time periods,that is in one graph i want to select jan 1st to Feb 31 of 2023,and in another i can select march 1 to april 31st in 2022,like wise random selection

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors