Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

 

SpeedWeightTemp
501200010
3012100-10
4012000-5
51200020
101200115

 

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

  • Anonymous , I doubt you can default the value like that for a slicer as of now

    • Anonymous's avatar
      Anonymous
      Not applicable

      I can't do that, because the below values are meant for different locations so we need that to chnage dynamically