cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vengadeshpalani Regular Visitor
Regular Visitor

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:

a.png

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:

op 1.png

 

EX 2:

b.png

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:

op2.png

2 REPLIES 2
v-danhe-msft Super Contributor
Super Contributor

Re: dynamic concatenation of fields based on user selection

Hi @vengadeshpalani ,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
vengadeshpalani Regular Visitor
Regular Visitor

Re: dynamic concatenation of fields based on user selection

Hi  

 

below URL has "dynamic Measure" and "dynamic dimenstion" based on user selection, but I want to create "dynamic concatenation" based on user selection. is it possible?

http://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi

 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 292 members 3,012 guests
Please welcome our newest community members: