Another Idea: I don't know if Power BI supports this though

[Anonymous]

Hi,

I had an idea for a project at work using Power BI but I'm not sure if Power BI supports this type of thing.

I want to have a SQL Query ran with Power BI ... (that part is simple).  But I also want to somehow use the 'slicer visual' in an unusual way.  I'd like to have a slicer visuals that allows the user to adjust these visuals for coulmn values on the fly.  I then have created measures that are dependent on these slicer values.  Really, it would act as a modeling tool

Now, I've used the slicer visual for Date Ranges numerous times before (where it allows the user to set the earliest and latest dates on the fly like this):

But is there a way to use the slicer visual where the user does not have to adjust both the min AND max?  I'd need the visual to only have one adjustment (if that makes any sense).  I'd just want the user to adjust one 'point'.  I'd repeat this for each value I'd want to incorporate and the create measures that update accordingly to these slicer visual's values.

Can this be done?

[v-jayw-msft]

Hi @Anonymous ,

You could use before or after instead of between.

Correct me if I misunderstand you meaning.

Best Regards,

Jay

[MFelix · Accepted solution]

Hi @Anonymous , 

One option for this is to setup the before or after option on the slicer and then setup a x number of days that add /reduce to that date. Something similar to:

FILTER (ALL( Table[Dates]), Table[Dates] <= MAX(SlicerTable[Date] && Table[Dates] >= MAX(SlicerTable[Date] - 150)

this is just the filtering part of the measure but can work. You can even have a slicer for the number of days you want to move forward or back.