Create independent slicers from existing columns.

[KinkyTail]

I am new to power BI and have been trying to create a dashboard but stuck at below steps.

I have a csv file which I imported and named it as 'DataSheet'
Now I want to create a calculator which concatenates some fields and looks up using those to calculate and find a price.

Say there are 6 columns in the sheet. Col1, Col2 and Col3 are in a hierarchy. I have created a table for each. Hence I want to click and select an option from each one of them. Upon clicking Col1, only those that are related to Col1 should be available in Col2 and Col3. I just dragged the fields, and created tables for each next to each other. Q1: Do I need to do something here to ensure users can pick only one option and that the relationship is not broken?

Next for Col4,Col5 and Col6 I want to create dropdowns. However, the dropdowns should be independent. i.e. users can select any of the distinct elements of Col4, Col5 and Col6 without affecting any other choices they make. Q2: How do I do that?

Subsequently, I need to concatenate all the selected fields. Q3: How do i create a concatenated field from selections?

[amitchandak]

@KinkyTail , You can disable interaction between visuals

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

Else you have to consider independent tables

Need of an Independent Table in Power BI - Exclude: https://youtu.be/lOEW-YUrAbE

[KinkyTail]

I could solve Q1 and Q2. For Q1 in slicer setting i just needed to turn the Single select option on. For Q2 I selected a slicer went to format and crossed all other slicers to make it independent. 

However, I am still struggling with using the selections made to create concatenaded fields