Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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;

 

 

 

 

 

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!

Need Help

8 Replies

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    8 years ago

    try changing the 

    'ParametreA'[Valeur ParametreA]


    to

    SELECTEDVALUE('ParametreA'[Valeur ParametreA])
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I have already set a measure;

       

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

       

      Still not working!

       

       FILE ABC

      • Stachu's avatar
        Stachu
        Icon for Community Champion rankCommunity Champion
        8 years ago

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

        Colonne = IF(Merge1[Hit]>MeasureA;"A";"Autre")
  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        8 years ago

        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