Same Year Slicer to obtain different frame time windows

DAX DAX Calculations
1

Hi,
I have a slicer with years.
When I select a year from that slicer, I want to obtain information on the selected year in a visual, but in another visual I want to obtain information from the previous year.^

image
image766×540 55.9 KB

I’ve looked for different solutions but I can’t get the desired result.

2

@JoaoMonteiro,

Disconnected table to the rescue.

  1. Create a disconnected table through Modeling, New Table

DisconnYr = VALUES( Dates[Year] ) and then use that field in your slicer.

  1. Harvest value from DisconnYr:

Harvest DisconnYr = SELECTEDVALUE( DisconnYr[Year] )

  1. Harvest previous year:

Harvest PrevYr = [Harvest DisconnYr] - 1

Now for your first table, set the filter condition for your Orders Qty measure to:

FILTER( Dates, Dates[Year] = [Harvest DisconnYr])

and for your second table, set the filter condition the same way, but use [Harvest PrevYr].

I hope that’s helpful.

  • Brian
3

Hi @BrianJ

Thank you so much for your help.

Regards
Joao Monteiro