Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I have an issue as I tried to set a parameter of WhatIf and then set my classes based on the selected value.
It does not work on my file... I have set my parameters as per below;
It seems like 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.
Whats' wrong with my formula? And I have posted the forecast$ to see the effect of the change on the classes, but nothing happens.
Thanks for your help!
Hi @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
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
Hi @Anonymous
Please refer to this article to learn how to use What-IF parameter.
Create and use a What if parameter to visualize variables in Power BI Desktop
Please try your formula and What-IF parameter in a measure instead of a calculated column.
Best Regards
Maggie
try changing the
'ParametreA'[Valeur ParametreA]
to
SELECTEDVALUE('ParametreA'[Valeur ParametreA])
I have already set a measure;
MesureA = SELECTEDVALUE('ParamètreA'[ParamètreA])
Still not working!
but you're not using it in the Colonne measure, try this:
Colonne = IF(Merge1[Hit]>MeasureA;"A";"Autre")
Colonne =
IF( Merge1[Fct $]>[MesureA];"A";"Autre")
Just did and still not working...
Have you look at the file?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
83 | |
75 | |
49 |
User | Count |
---|---|
142 | |
141 | |
110 | |
69 | |
55 |