Comparative graph between 2 years

[Syndicate_Admin]

Hello, I am new to PowerBi and I need your help.

I need to make a comparative graph between 2 years and I am not achieving it.

I have a sales table with date and years, I have added in my report the 2-year filter where the user must choose the years he wants to compare.

It happens that when I select the years in these filters (e.g. 2021 and 2022) and my graph goes blank, can they help me to achieve my goal please?

Thanks in advance

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

I'd like to suggest you to create a independent slicer table:

Slicer = distinct('table'[year])

Then create a measure like below and add it to visual filter set value = 1.

Measure = IF(SELECTEDVALUE('Table'[year]) in VALUES(slicer[year]),1,0)

If I misunderstood your meaning, please share some sample data and expected result to us.

Best Regards,

Jay

[amitchandak]

@Syndicate_Admin , if you have date, with help from date table or date of your table

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))