Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

dynamic concatenation of fields based on user selection

Hi all

i have data like below table 

 

Field 1Field 2Field 3Field 4Field 5Field 6
abbacadaeafa
abbacadaeakk
acbbcbdbebfb
adbcccdcecfc

 

I want to create dynamic concatenation based on dimension selection filter 

 

EX 1:

I have selected "Field 1", "Field 2", "Field 3" in Dimensions selection filter & i have selected "Field 6" in Measure selection filter, so I want to concatenate three fields ( "Field 1" + "Field 2" + "Field 3") & based on this concatenation I want to show count distinct "Field 6" value 

Expected output:

 

EX 2:

I have selected "Field 2", "Field 4" in Dimensions selection filter & I have selected "Field 5" in Measure selection filter, so I want to concatenate two fields ( "Field 2" + "Field 4") & based on this concatenation I want to show count distinct "Field 5" value 

Expected output:

Need Help

2 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous ,

    Based on my research, I am afraid you could not to use multiple columns as slicer in Power BI and also could not use measure in slicer too.

     

    Regards,

    Daniel He