cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pamboys09 Regular Visitor
Regular Visitor

Slicer 0% to 100% Dynamic

Is it possible to create a slicer from 0% to 100% lets call this Utilization.

312321321321.PNG

then i can create a measure for example:

Measure = sum(BOX AMOUNT TABLE)*Utilization  <--- slicer

my goal is for user to decide on what Utililization to use and the Measure will calculate it for them?

My question is how to make the slicer. 

 

hope it makes sense.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Slicer 0% to 100% Dynamic

@pamboys09 

 

You may take a look at Create and use what-if parameters to visualize variables.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Tad17 Established Member
Established Member

Re: Slicer 0% to 100% Dynamic

Hey @pamboys09 

 

Check out these two threads to see if they answer your question:

 

https://community.powerbi.com/t5/Desktop/Dynamic-Slicer-based-on-Slicer/td-p/429694

 

https://community.powerbi.com/t5/Desktop/Dynamic-slicer-selection/td-p/475638

 

The solution to the second one is closer to what you are looking for I believe (the solution in that one is links to other possible solutions... the irony).

 

If this helps please kudo my post.

If it solves your problem please accept it as a solution.

pamboys09 Regular Visitor
Regular Visitor

Re: Slicer 0% to 100% Dynamic

Unfortunately the one im looking for is something like these

The Visualization that drag slicer to pick a % from 0% to 100% and i can use  that to calculate measures.

 

Is that a custom Visualization? because the default slicer only have inBetween not single selection for something to drag.


32134215034215.PNG

pamboys09 Regular Visitor
Regular Visitor

Re: Slicer 0% to 100% Dynamic

Oh i got it now. nevermind! thank you

Community Support Team
Community Support Team

Re: Slicer 0% to 100% Dynamic

@pamboys09 

 

You may take a look at Create and use what-if parameters to visualize variables.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors