Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tooba
Frequent Visitor

JSON file and embedded fields

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.

11.png

I tried to use pivot, but I got following error:

12.png

 

I appreciate if some one could help me to solve the issue.

 

Kind Regards,

 

1 ACCEPTED SOLUTION
tooba
Frequent Visitor

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:)

View solution in original post

3 REPLIES 3
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @tooba,

 


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

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

tooba
Frequent Visitor

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:)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.