cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Clara Member
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:

 

reality.png

 

 

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

 

expectation.png

 

How would I achieve that?

2 REPLIES 2
Community Support Team
Community Support Team

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

@Clara 

 

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.
Clara Member
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).

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

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?

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

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!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors