Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have a field in a JSON file that includes a lot of information about my customer.
The structure is as following :
[{"Customer name": David, "lname":Orely, "ID": null, , "CUSTOMFIELD": [{"CUSTOM_FIELD3": male, "CUSTOM_FIELD":Cluseter Co-lead }]}]
Cluseter Co-lead is a role of David.
Power BI converts above data in a from that is shown in the screenshot.
Now customer question is this: number of professors based on their gender! If I fieldter custom_field_id to contact_field_3, then I have no way to filter custome_field _id to contact_field_7.
I tried to use pivot, but I got following error:
I appreciate if some one could help me to solve the issue.
Kind Regards,
Solved! Go to Solution.
Hi,
I solved a problem in this way:
I created a copy of my data source in power BI, then filtered one of my sources based on contact_field_7 and filtered the copy of my source based on contact_fileld_3 and join them based on unique identifier.
It worked fine for me:)
Hi @Anonymous,
Now customer question is this: number of professors based on their gender! If I fieldter custom_field_id to contact_field_3, then I have no way to filter custome_field _id to contact_field_7.
Could you please provide more description about the quoted message? Based on above table, what structure do you want to convert to?
Regards,
Yuliana Gu
Hi,
I want to filter contact_field_7='Cluster Co-LEad' and contact_field_3='male.
contact_field_7 and contact_field_3 keep different information about one person(in this casse person's role and gender'). But they are fetched as different values of field'custom_field_id'. How can I apply this filter(contact_field_7='Cluster Co-Lead' and contact_field_3='male.)?
Regards,
Tooba
Hi,
I solved a problem in this way:
I created a copy of my data source in power BI, then filtered one of my sources based on contact_field_7 and filtered the copy of my source based on contact_fileld_3 and join them based on unique identifier.
It worked fine for me:)
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.