Forum Discussion

subburaj's avatar
subburaj
Helper I
6 years ago

Dynamic Column from selected value from two fields

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.

 

 
Tips and Tricks

4 Replies

    • subburaj's avatar
      subburaj
      Helper I
      6 years ago

      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.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    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

  • subburaj's avatar
    subburaj
    Helper I
    6 years ago

    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