Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer 0% to 100% Dynamic

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

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.

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey Anonymous 

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.


      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Oh i got it now. nevermind! thank you