Dynamic Column from selected value from two fields

[subburaj]

Hi Friends -  I would like to create new dimension using the value selected from two fields, for an example below. “CCC” is selected in one slicer and “IN” is selected in another slicer. I want to have new field which shows items of CCC, IN. Please help.

[subburaj]

I’m sorry, I should have told you why want in that way. This is for the comparison measure between WoB Country Vs BoB country. User will select WoB country in vertical slicer and BoB country in horizontal slicer. so I want to have new dynamic column with SELECTED country from both the slicer, and then I will put them in x axis of the column chart.

Please help

[v-easonf-msft]

Hi , @subburaj 

According to your description, I do not quite understand your question.
Could you please share your PBIX/some sample data and expected result to me if you don't have any Confidential Information?
You can upload your pbix file to OneDrive and share it with me if it is convenient.
Remember that you should remove security and sensitive data within the report.

Best Regards,
Community Support Team _ Eason

[Mariusz]

Hi @subburaj 

I think you have missed the example?

Thanks

[subburaj]

I’m sorry, I should have told you why want in that way. This is for the comparison measure between WoB Country Vs BoB country. User will select WoB country in vertical slicer and BoB country in horizontal slicer. so I want to have new dynamic column with SELECTED country from both the slicer, and then I will put them in x axis of the column chart.