Dynamic slicer to change measure value

[Anonymous]

Hi

I need to create a slicer with, say, 5 numerical entries. These numerical entries should be able to change a particular measure. For example,

Slicer entry = 0.5 / Measure = 10 - if I click on the slicer the measure will change to 5

Slicer entry = 0.75 / Measure = 10 - if I click on the slicer the measure will change to 7.5

Is this possible and how would I approach the problem?

Thanks!

[v-deddai1-msft]

Hi @Anonymous ,

Have you solve your issue? Would you please try to accpet the useful reply as answer to help others find it more quickly.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Anonymous]

perfect, thankyou

[Tahreem24]

@Anonymous  - 

Try this steps:

Step 1: GO to Modelling tab --> New Parameter --> and so like the below screen shot.

Step 2: Then create a new measure as per your logic:

MEASURE = 'Dynamic Slicer'[Dynamic Slicer Value] /SUMm(Table[Measure])

Step 3: Take slicer of the step1 value and keep changing the value and see the result.

[Tahreem24 · Accepted solution]

@Anonymous  after follow the above mentioned steps you'll get something like this.

P.S. please create measure as per your logic. I simply divide Dynamic slicer value with constant measure value i.e. 10.

[amitchandak]

@Anonymous , You need whatif parameter of measure slicer not clear

what if -https://docs.microsoft.com/en-us/power-bi/desktop-what-if

measure slicer
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern