Dynamically shifting the dates (X Axis) based on user selection in a Slider

[Anton93]

Hi, 

Considering I have a database with a column "Actual date" (X axis) to be plotted with my "P Capacity" (Y Axis) and another column "Actitivty" (Legend), it is easy and straightforward to select a Stacked Column Chart. 

Now I need to introduce a functionality where the user can select by how many days they want to shift the "Actual date" by using a slider and this should be added to the "Actual Dates" and then plotted. 

Ex: Assuming the user selects 15 on the slider, the new values will be plotted from the 16th of January: 

Unfortunately I am unable to create a link between the slider and the X axis. What I have been able to try is: 

1. Introduce a new column that can add "X" number of days to the actual. Plot this new column as the X axis, so that when I manually change the value X in the formula, it works. 

Formula: 

NewDateColumn = DATEADD(Tabelle1[Actual date].[Date],"X",DAY)    (Where I replace "X" with value I want like 15) 

But I would want this value X to be taken from the slider! 

I did try using Measures, but they can't be used as an axis. 

Any suggestions?

[Jidnyasa2904]

Hello Anton93, 

If you have found the solution to your question above, could you please share it? 
I have a similar query, I want to present a comparison of sales TY and LY on a Line Chart. But the event dates are off my one week. The date shift slicer would work perfect, similar as yours. 

[v-yanjiang-msft · Accepted solution]

Hi @Anton93 ,

Firstly we can't create a dynamic column, in other words, we can't use a dynamic measure in a calculated column.

According to your description "Assuming the user selects 15 on the slider, the new values will be plotted from the 16th of January", if you mean the visual will be filtered to 16 to 31, here's my solution.

Create a measure:

Measure =
IF ( MAX ( 'Table'[Actual date] ) > 'Parameter'[Parameter Value], 1, 0 )

Put the measure in visual filter and select show items when the value is 1.

After apply filter, get the result:

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.