Filter the bars of a bar chart dynamically

[Syndicate_Admin]

Hello everyone

I need to make a comparison of the total sales between two periods in a bar graph, without the need to show the year in the legend, but rather create two year selection criteria and that each of the criteria allows to modify a bar and not both.

For example

Filter 1
Bar 1

Filter 2
Bar 2

[v-easonf-msft · Accepted solution]

Hi， @Syndicate_Admin 

Please try the following steps:

1. Copy a new table 'Table2'

calculated table:

Table2 = Table1

2. Enter the following table:

3. Add the following mesure to the bar graph to compare the results

Sales =
SWITCH (
    SELECTEDVALUE ( 'Comparison Table'[Bar] ),
    "Bar1", SUM ( Table1[Sales] ),
    "Bar2", SUM ( Table2[Sales] )
)

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Syndicate_Admin , refer

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

or

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg