- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what if parameter| one slicer to change each row in a column
Hello everyone,
Is it possible to change each row of a column with only one slicer of a what if parameter and a list ?
I would like to have something like the picture attached, to have new price for each product, with saving the new values of all rows.
Can someone help me out with this please, thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
By my research, I'm afraid that we cannot achieve your desired output as measure will changed by the filter context.
Best Regards,
Cherry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can someone help me with this please ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
I have a little confused about your desired output.
Do you want to get the output below?
If it is, you could use the measure Parameter value which is created automatically when you create the what if parameter.
If you need any other help, please share your desired output so that we could help further on it.
Best Regards,
Cherry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @v-piga-msft ,
Thank you for your answer, but I would like to give different value for each row like the picture billow, not the same value for all of them.
Best regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I've tried this measure in the pictures bellow,
butt once I change the product, I loose the value of the other one
Can someone please help me with saving all the values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello everyone ,
how do I change each product price based on the user input from the slicer
I would like to reach to following, like in the picture billow
Thank you in advanced.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
Sorry for the delay.
To get your expected output, please follow the steps below.
1. Create a calculated table with VALUES function.
Table = VALUES(Table2[product])
2. Create the measure with the formula below.
Measure = VAR a = SELECTEDVALUE ( 'Table'[product] ) RETURN IF ( ISFILTERED ( 'Table'[product] ), IF ( MAX ( 'Table2'[product] ) = a, [para Value], MAX ( 'Table2'[price] ) ) )
Then you could create the slicer with the Product column in the calculated table.
Here is the output.
More details, you could refer to my attachment.
Best Regards,
Cherry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @v-piga-msft ,
Thank you so much for your answer and your attachment, but what I would like to have is different.
I would like to be able to keep the values that I choose each time ,
for example, in your picture attached product_3 have 420 as a new value, so when I select product_4, I would like that product_3 keep the 420 value and not get the default price.
I hope I explained well this time ,
Thank you again for all your help
Best Regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found solution. Not is the best solution mas it is worked for me.
I created one whats if param for each row in my table (=~ 20 rows) and switch it in dax expression.
Medida =
VAR __SELECIONADO = SELECTEDVALUE(Mercadologico[descricao])
RETURN
SWITCH(
TRUE();
__SELECIONADO = "ACOUGUE";ddACOUGUE[DDDV Valor];
__SELECIONADO = "ALIMENTOS";DDALIMENTOS[DDALIMENTOS Valor];
0)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
By my research, I'm afraid that we cannot achieve your desired output as measure will changed by the filter context.
Best Regards,
Cherry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-06-2024 07:29 AM | |||
02-27-2024 09:04 AM | |||
03-14-2024 10:50 AM | |||
09-24-2024 06:58 AM | |||
Anonymous
| 04-09-2024 02:44 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |