Parameters

[Anonymous]

Hi

I created the following parameter, attached to a slicer to be able to modify its value. As follows:

Then I created a custom column, where I would like that each line value is automatically set to that parameter value. I did as follows. But as you can see it does not work. Do you know how to proceed?

[Anonymous]

Thank you all!

[v-xicai · Accepted solution]

Hi @Anonymous ,

What if parameter can only be used in measure instead of calculated column, so you can create measure like DAX below.

Meaure1= Parameter[Parameter Value]

You can learn more:https://docs.microsoft.com/en-us/power-bi/desktop-what-if.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Calculated column can not take dynamic value from the slicer. So think how can you get the same as a measure .

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

[Greg_Deckler]

@Anonymous You cannot have a calculated column interact with a slicer since columns are only calculated at data load/refresh.