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
Anonymous's avatar
Anonymous
Not applicable
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