Want to achieve same Functionality as Qlik's PICK(MATCH()) in PowerBI.

[Parth]

Hello members,

I am facing a issue while doing data modeling for one dashbaord and details of the issue as per below.

I have One Dashbaord in Qlikview and I am replacing that dashboard with my new Power BI Dashboar.

So in QLikview they have used Pick(Match(Upper(ColumnLabel),$(vColumnLabel)),$(vActualColumn)).

so basically in above expression in Qlikview they are Matching "ColumnLabel" value to "$(vColumnLabel)" variable value, if it get matched then in "$(vActualColumn)" varible they have actual column name and pick function we pick up that actualt column and display its value in table.

here in power BI I have one table with column name ColumnLabel. it will have Column name so based on ColumnLabel's value I have to pick up actual that column from data model and display value. 

Table_Test

--------------------------

No         ColumnLabel

---------------------------

1            CustomerName

2            SupplierName

3            ProductName

4            ItemName

So when ColumnLabel = $(vColumnLabel) i.e. suppose "SupplierName" then I have to show actual supplier name column value in that table in power BI dashbaord.

Hope i able to explain the issue clearly.

Here i am not cleqr how we can do this in Power BI or what is the exact replacement of "Pick(match())" function in PowerBI

Regards

[Parth]

Hello @amitchandak ,

Thanks for reply.

Actually i have explored this option and it is not fitting into my requirement. If you go through my requrement in detail as described in my que. i need value to be shown dynamically without slicer or anything.

In my case I will have one column lets say column 'A', this column 'A' will contain value like "Customer Name", "Supplier Name", "Address" ... etc and in our model we will have this all as a field. so if Value of 'A' column is "Customer Name" than we have to show actually "Customer Name" fileds value.

I hope i am able to explain you my issue clearly.

[amitchandak]

@Parth , Based on what I get seems like you need a dynamic axis/row/column. 

if yes, refer field parameters https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...