cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

## 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?

1 ACCEPTED SOLUTION
Community Support

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
Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
2 REPLIES 2
Community Support

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
Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors