Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Anonymous
You may take a look at Create and use what-if parameters to visualize variables.
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.
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.
Oh i got it now. nevermind! thank you
@Anonymous
You may take a look at Create and use what-if parameters to visualize variables.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |