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.
Hi ,
I've a issue here. I am trying to create a relationship between two tables as shown in the picture. I am looking to have one table that filters Minimum requirement, actual skills , Description, current positions based on the name that i have in slicer. For some reasons I am getting the duplicate values in my table and i couldn't able to figure it out where it is coming from.
Any help would be greatly appreciated.
Thanks,
Solved! Go to Solution.
Hi @Gowtham30 ,
Click the visual>go to field>right click the column(not showing all the data)>"show item with no data":
Check whether this way will present all the data.
@Gowtham30 , You can create a concatenated column and use that as key
key = [col1] &"-" & [col2] &"-"& [col3]
Hi Amit,
Thanks for your reply, I tried merging two columns in both tables and used as a key. When i was trying to plot the tables the output looked liked this. The required value columns comes empty. I am still missing some connections i guess. Thanks,
Hi @Gowtham30 ,
In your oringinal post,as the relationship between the 2 tables are many to many and you dont have a unique key,that's why you have duplicate values.
And in the last reply,as the direction in the relationship is single,so it may filter out some value,pls try to change the direction from single to both,see below:
Hi, @v-kelly-msft @amitchandak
I did change the filtering to both ways but my model still not pulling any values in the required value column.
Please advise.
Thanks,
Hi @Gowtham30 ,
Click the visual>go to field>right click the column(not showing all the data)>"show item with no data":
Check whether this way will present all the data.
Somebody help, Please.
Thanks !!
Hi Amit,
Thanks for your reply, I tried merging two columns in both tables and used as a key. When i was trying to plot the tables the output looked liked this. The required value columns comes empty. I am still missing some connections i guess. Thanks,
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |