Clustered Bar Chart filtered to Selected Year & Prev Year

[cheezter88]

Been racking my brain on this and have scoured this site and many others for an answer.

My data is in the following format:

firstUserDefaultChannelGroup	sessions	year
Paid Search	1000	2024
Paid Search	900	2023
Referral	100	2024
Referral	90	2023
Organic Social	1500	2025
Organic Social	1000	2024
Organic Social	750	2023
Paid Other	200	2024
etc.	etc.	etc.

I have Clustered Bar Chart built in the following way:

I have a slicer on the page for [year] that filters other visuals to show just the selected year, only 1 year may be selected at a time.
I need the Clustered Bar Chart above to only show the selected year and the previous year (i.e. 2024 is selected in slicer so the Bar Chart shows data for 2024 & 2023), other than that the above Bar Chart is exactly what I need.

I have tried the follwoing measure to create a new source for [sessions]:

Measure =

    var filteredYear = SELECTEDVALUE('PROP - GA4 SourceMedium'[year])

return

    CALCULATE(SUM('PROP - GA4 SourceMedium'[sessions])

        ,REMOVEFILTERS('PROP - GA4 SourceMedium')

        ,'PROP - GA4 SourceMedium'[year] = filteredYear

            || 'PROP - GA4 SourceMedium'[year] = filteredYear - 1

    )

This provides weird total numbers for all [firstUserDefaultChannelGroup] and only shows the filtered [year] instead of 2 years.

I have also tried the following measure to use the visual level filter but have not had any luck with those either. I am unsure if [year] being within the Legend part of the visual has caused any additional issues. 

Any help is greatly appreciated!

[Ritaf1983 · Accepted solution]

Hi @cheezter88 
To get the wanted result you need a disconnected years table  ( for the slicer):

Then you can create a flag measure like :

flag =

var selectedY =

SELECTEDVALUE(Years[year])

var PreviousY = selectedY-1

Return

if(SELECTEDVALUE('Table'[year])= PreviousY || SELECTEDVALUE('Table'[year])= selectedY,1,0)

This measure will be a filter for the graph :

The pbix is attached

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