Switch based on the columns

[caduwek]

Hello,

I have many calculated fields (100+) which I would like to add into the graph based on the sellection. Graph should show only one metric which I choose in the dropdown menu.

For this I created table where is name of these metrics (which I would like to select) and name of the calculated fields (calculation behind) :

Name metric                name calculated field

number of clients         cnt_client

amount of credit           amt_credit

...

...

...

Then I have there switch which chose calculated field based on the sellected name. 

Bu question:  Is possible to create switch like

switch(table[Name metric], selected table[Name metric], '[table[name calculated field]]' - take calculated field which has same as in the table) in one row instead write every possibility for each name metric one by one?

Thank you

[v-lionel-msft]

Hi @caduwek ,

Maybe.  Can you give a specific example data?

Best regards,
Lionel Chen

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

[amitchandak]

I think this link can help. But seems like you already have this method

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...