Wide to Long Data Visualisation Filters

[redholt]

Morning,

I have a survey data set that originally was wide, with a columns for person infromation and questions and each row containing a single persons information and responses. 

I have changed this to a long data set becuase of how I wanted some visualisations to work within my report which has worked for the most part. So I have 2 tables, one with personal information and an index, and another with the questions and answers along with the linked index that identifies the respondent.

However, when using the long data set any visualisation that I setup does not filter on other visuals when I click on certain datapoints as was the case when it was setup in the wide format. For example, clicking age group would filter responses for that group in the wide format but in the long format it just highlights the point I have clicked.

Just wondering if I am missing something obvious with this as I want the long data to allow users to have dynamic filtering when browsing the report. 

Any help is appreciated

[amitchandak]

@redholt , You have to share some samples. Long format should allow drill across. But long and wide might not filter each other with they are not connected

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.