cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AW1976NOVA
Post Patron
Post Patron

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

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

Capture.PNG

 

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?

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @AW1976NOVA , 

 

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @AW1976NOVA ,

 

You could use before or after instead of between.

8.PNG

Correct me if I misunderstand you meaning.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
MFelix
Super User
Super User

Hi @AW1976NOVA , 

 

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!