cancel
Showing results for
Did you mean:
Highlighted
Member

## Same period each year in chart? (Timeline Slicer + Line Chart)

Hello all!
I am using a Timeline Slicer through a calendar table to extract the total of sales in a measure I have called "SumSalesTY":

SumSalesTY =
VAR LimMin = FIRSTDATE(Calendar[MonYear])
VAR LimMax = LASTDATE(Calendar[MonYear])

RETURN CALCULATE(
SUM(Table1[Sales]),
ALLEXCEPT(Table1,Table1[Date],Table1[Unit]),
Table1[Date]>=LimMin,
Table1[Date]<=LimMax
)

It works well in a card visual, but I'm stuck as to how I can use it in a line chart.

Here's how my report looks so far:

The timeline slices through Calendar[MonYear] and is filtered to show only the "last" 24 months (actually jan-dec 2018 and 2019).

The yellow chart is only showing the sales total for Mar-Apr/2019, but actually I wanted it to show previous years as well (sales total for march+april each year):

How would I achieve that?

2 REPLIES 2
Community Support Team

## Re: Same period each year in chart? (Timeline Slicer + Line Chart)

You may apply virtual relationship in DAX measure.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: Same period each year in chart? (Timeline Slicer + Line Chart)

Thanks @v-chuncz-msft , but how would I do that? My timeline slices through Calendar[MonYear], which is (indirectly, I guess?) in a real relationship with Table1[MonYear]. (I say indirectly because in fact, I've linked Calendar[Date] with Table1[Date], though both tables also have "MonYear" columns.)

I can attest that the relationship works because I've checked that 5.3 M really is the total of sales for March+April 2019 (as in the example above).

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!