Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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:)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
74 | |
57 | |
39 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |