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
Power-CJ
Helper I
Helper I

No Filter Contex after Transforming Table in Power Query for Frequency Distribution

Hello there,

 

In my dataset, I have a set of people in rows with different sociographic attributes in the columns, like age, job, married and so on.

 

In addition to that, there are many columns with characteristic attributes. Most of the expressions range from 0 to 5, where 0 stands for no answer, and then it goes from "absolutely not" to "absolutely." These values represent the responses from a questionnaire.

 

I was building a report to analyze the frequency distribution of the characteristic attributes depending on the answers from 0 to 5.

 

Therefore, I performed a transformation in Power Query, and it worked fine. I created a new table for each characteristic to conduct the transformation for the frequency distribution. I unpivoted this table to convert columns into rows.

 

However, the filter context is not working in the report. I can't filter with the sociographic attributes. The new tables I generated use function reference by right-clicking on the original table.

 

Filter context is not working, and I can't create relationships between the tables due to a missing primary key.

 

How can I solve this problem?

 

Thank everybody for supporting me in this case

1 ACCEPTED SOLUTION

I didnt realise the magic of power query till now

the solution is so easy cant belive

thanks

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

Why have you create multiple table.  There should be just one unpivoted table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

hi, thanks for your response.

because i need the origin table like it is. the child referenes tables are only there for a visual to show the distribution of the answears in a specifition column.

 

Also if there will be one unpivot table, i'm not able to define a realationship betwenn both

I do not see the relevance of multiple tables.  Share some data to work with and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

I didnt realise the magic of power query till now

the solution is so easy cant belive

thanks

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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.