Forum Discussion
Comparative graph between 2 years
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
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
2 Replies
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])))
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
