Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Names | Full names | income | |||
AMIT | AMIT das | 50000 | |||
SANA | AMIT tode | 40000 | |||
AISH | AMIT faruq | 230000 | |||
AISH dole | 300000 | ||||
AISH wai | 500000 | ||||
Hello Everyone, I have two tables , 1st table consists of starting name, and 2nd table consists of full name. I want to display chart for all entries present in table 2 if I select data from table 1.
For eg. If I select AMIT from table1 ,then it should select all amit in table 2, and display the income chart
Solved! Go to Solution.
@ajitrikibe Here is the step you need to do in "Power Query" using "Split Column" option.
Please note - Your data might have middle names as well but still you might need to join only first name (string upto to first space).
Proud to be a PBI Community Champion
@ajitrikibe Here is the step you need to do in "Power Query" using "Split Column" option.
Please note - Your data might have middle names as well but still you might need to join only first name (string upto to first space).
Proud to be a PBI Community Champion
try to create new column in table2, for example
shortName = left([Full names];4)
and create link betweem to tables t1[Names](1)->(*)t2[shortName]
Why don't you try splitting the Full Name column using Power Query Editor?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |