Forum Discussion
Pareto classes with WhatIf
Community SupportHi Anonymous
Based on my test in your file, I found It may be some misunderstanding with the usage of What-if parameter and table visual.
First, you should use What-if parameter in a measure so that when you select values on the What-if parameter slicer, the measure would change with the slicer. Note, calculated columns can be changed by slicers.
Second, pay attention to your table visual, you add [Fct $] column in the table, and apply "sum" aggregation for this column, thus, [Fct $] column will sum by other columns in this table visual.
These are why " the data is only keeping what is set as the default, when I change the value in the parameter, there is not effect on the table".
Look at a test below.
create a measure
Measure = IF( MAX(Merge1[Fct $])>[MesureA],"B","Autre")
Then add this measure to the table visual but don't set the Merge1[Fct $] as "sum", set it as "don't summarize".
Best Regards
Maggie
Thanks for the help Maggie, that works very well.
Although, can I use that measure to finalize my table with a column with the proper value. (add measure to a column; I tried as Column = Measure ; but all values are referred to B.
If I change the whatif parameter, can it update a column of my class ("B") and then it would update my whole dashboard using that setting. I understand the point of the measure, but I need that value in a column so I can complete all my dashboard.
Let me know!
Thanks
- v-juanli-msft
Hi Anonymous
It is not possible to use a measure in a column directly.
Also, a column can't change values with the slicer or parameter.
If you want the value to change with the selection in a slicer or parameter, you can use a measure.
If my answer helps you slove your question, could you kindly accepted this as a solution?
Best Regards
maggie