Display current year and next year data in one visual based on Year slicer selection.

[Jitmondo]

Hi all

Not sure if this is possible,I have a line and stacked column chart that can be filtered by year individually and combined for 2021,2022, and 2023. It currently shows all years and months in the correct order when nothing is selected in the year slicer.

I want to be able to select a year and have my line and stacked column chart display that year and the next year figures. If I select 2021 on my year slicer, I want to only see 2021+2022 or if I select 2022 I want to see 2022+2023 only.

I am not sure if I should be trying a specific dax function or if this is just something thats not possible

Thanks 

[Jitmondo]

Due to time restraint I ended up producing the view with a slider. Thanks for your advice I will look to try it out when I get a chance 🙂

[jaideepnema]

Hi @Jitmondo ,
There might be a better way of doing this. I tried to recreate your scenario with one fact table containing data and one date dimension table containing the date values. I removed the relationship between these tables in order to avoid filtering and create a following measure

Filter = 

var selectedyear=SELECTEDVALUE('Dim Date'[Date].[Year])

var filtercalc=IF(YEAR(SELECTEDVALUE('Data'[Date])) in {selectedyear,selectedyear+1},1,2)

return filtercalc

Now i used this measure in visual level filter and applied the filter 1 to take all records that the required filtering criteria on the graph(clustered column chart).

Please find attached the PBIX file for your reference. Let me know if this helps !!

Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[Jitmondo · Accepted solution]

Thanks jaideepnema will give this a go and let you know how I get on thanks!