Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
Anonymous
Not applicable

Pareto classes with WhatIf

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;

 

2.PNG

 

 

 

3.PNG1.PNG

 

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!

8 REPLIES 8
v-juanli-msft
Community Support
Community Support

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".

1.png

2.png

 

Best Regards

Maggie

Anonymous
Not applicable

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

v-juanli-msft
Community Support
Community Support

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

Stachu
Community Champion
Community Champion

try changing the 

'ParametreA'[Valeur ParametreA]


to

SELECTEDVALUE('ParametreA'[Valeur ParametreA])


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Anonymous
Not applicable

I have already set a measure;

 

MesureA = SELECTEDVALUE('ParamètreA'[ParamètreA])

 

Still not working!

 

 FILE ABC

Stachu
Community Champion
Community Champion

but you're not using it in the Colonne measure, try this:

Colonne = IF(Merge1[Hit]>MeasureA;"A";"Autre")


Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Anonymous
Not applicable

Colonne =

IF( Merge1[Fct $]>[MesureA];"A";"Autre")

 

Just did and still not working...

 

Have you look at the file?

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.