Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

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 th...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
amitchandak
Super User
4 years ago

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])))