Forum Discussion
Anonymous
3 years agoNot applicable
Sync Parameters
Hi Team,
I have created three Parameters Sort 1, Sort 2, Sort 3, which is from 1-100. I have added these 3 parameters in slicer. I would like to sync these three slicers like if I have selected 20 in first 30 in second it should automatically take 50 for lst one. so that three valuves cummulativey make 100.
I have data like below
| Speed | Weight | Temp |
| 50 | 12000 | 10 |
| 30 | 12100 | -10 |
| 40 | 12000 | -5 |
| 5 | 12000 | 20 |
| 10 | 12001 | 15 |
I have created a measure like below:
Speed filter = 'SORT 1'[SORT 1 Value]*(5/100) + 'SORT 2'[SORT 2 Value]*(18/100)+ 'SORT 3'[SORT 3 Value]*(27/100)
Range =
VAR A = ROUND('Sheet 1'[Speed filter],0)
RETURN
DIVIDE(264,CALCULATE(AVERAGE('Sheet 1'[EnergyPerKm]), FILTER('Sheet 1', 'Sheet 1'[Speed]=A)),0)
I'm unable to add PBIX file. Please help me with solution.
Thank you
2 Replies
- amitchandakSuper User
Anonymous , I doubt you can default the value like that for a slicer as of now
- AnonymousNot applicable
I can't do that, because the below values are meant for different locations so we need that to chnage dynamically