ADDING COLUMN VALUES TO SELECTED PARAMETER

MiteshY — Thu, 23 Feb 2023 18:25:55 GMT

Hello All,

I have one question and i am not sure is it possible in power bi or not.

There is a column of user name in table and i want to specify some criteria to it based on user selection.

Eg. Column name is user name and i have created one table name Selection.

I want to add user name to selection which i have made.

Suppose username is Cat and in selection there are 2 dropdowns Animal and Not animal.

So if someone selects Animal then value sholud be added to animal field in selection.

In this way i want dynamic value based on selection ,

PLEASE HELP, IF WE CAN APPLY THIS IN POWER BI OR THERE ARE SOME OTHER WAYS TO ACHIEVE.

Thanks.

Re: ADDING COLUMN VALUES TO SELECTED PARAMETER

Anonymous — Wed, 01 Mar 2023 02:53:16 GMT

Hi @MiteshY,

Current power bi does not support create dynamic calculated column/table based on filter selection, you may need to write measure formula that can be interacted with filter selection to instead.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Regards,

Xiaoxin Sheng

topic ADDING COLUMN VALUES TO SELECTED PARAMETER in Developer

ADDING COLUMN VALUES TO SELECTED PARAMETER

Re: ADDING COLUMN VALUES TO SELECTED PARAMETER