Forum Discussion

cyclist007's avatar
cyclist007
Responsive Resident
7 years ago

Using selected value of what if parameter in a Calculated column

I am trying to get a number input from the end user using the What if Paramater. I would then like to use that number in a calculated column and show the calculated column as a category on a colum...
Need Help
Show and Tell
Tips and Tricks
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi cyclist007 ,

Your issue is caused by that you created the calculated column with parameter value which is not dynamic. If you create the measure with parameter, it will work fine. 

However, we can't use measures as an axis at the moment, just columns are supported for the use on axis. 

So, I don't think that we could achieve your desired X axis in Power BI Currently.

Best  Regards,

Cherry

 

  • cyclist007's avatar
    cyclist007
    Responsive Resident
    7 years ago

    Thanks v-piga-msft for responding. 'Paramater Value' is a measure (or else what is it?) And I was using the Measure in a Calculated column - now I understand the calculated column would not get recalculate on change in measure/paramter value but was hoping at least clicking on refresh data would help? Is there anyway the calculated column can be forced to recalculate (by the end user)?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I am having the same issue. I can not create measure and it has to be a calculated column. Is there a way of having the value I decide in one of the columns so that I can use it in the calculated column?

      Or createing measure is only the way?

       

      Thanks

      Nagaraj