filtered dCalendar

Question

Hi, guys. It is possible to create a filtered table, so that it is an auxiliary dCalendar, with a date range according to the date chosen by the user? For example, in the graph below, I would like only the data from 12/31/2021 to 01/09/2021 to appear. That is, instead of putting my complete dCalendar on the x-axis I would put the filtered.

pauldbrown · Answer

Can't you use the regular date slicer set to "Between"?

&nbsp;
You will need a Calendar Table for that though

steph0018 · Answer

Hi, Paul,&nbsp;the intention is for the user to choose only one date.

pauldbrown · Answer

...and the measure calculates what date range?

steph0018 · Answer

SELECTEDVALUE(dCalendario[DATA]) and&nbsp;LASTDATE(PARALLELPERIOD(dCalendario[DATA],-1, YEAR))&nbsp;

pauldbrown · Answer

&nbsp;
Do you want to see the data for the last year based on the date selected?
&nbsp;
See if this works for you.
1) Duplicate you date table using (I've called the duplicate "Period Filter") new table in the ribbon and
&nbsp;
Period Filter = 'Calendar Table'
&nbsp;
Join this table to the Calendar table in a1-to many inactive relationship with a single filter direction from the Period Filter Table to the Calendar Table. The model should look like this:

Now add the slicer from the calendar table, and create the visual using the date field from the Period filter table as the axis.
Create a measure along these lines:
&nbsp;
Data by sel date = 
VAR CalD = MAX('Calendar Table'[Date])
VAR SelPeriods = DATESINPERIOD('Period Filter'[Date], CalD, -1, YEAR)
RETURN
CALCULATE([Sum of Sales], 
REMOVEFILTERS('Calendar Table'),
KEEPFILTERS(SelPeriods), 
USERELATIONSHIP('Calendar Table'[Date], 'Period Filter'[Date]))
&nbsp;
&nbsp;
Add this measure to the visual and you will get:

&nbsp;

Forum Discussion

filtered dCalendar

10 Replies

Related content

Filter

Dynamic Filter

Inverse Filter

Problem in generate dCalendar

Override filters