2-way Cross-filtering between multiple-table visuals

[inderz]

I have four tables of Traffic accidents for 2015 in India, State-wise. These are location of accidents (open areas, residential areas etc), Visibility, Vehicle Type and Time of Accident.

I need to create a dashboard that allows cross-filtering as under :-

- Selecting one of category of Visibility > the Time of Accident, vehicle Type and Location of Accidents bar-chart must get filtered.

- Selecting one of category of Vehicle Type > the Time of Accident, Visibility and Location of Accidents bar-chart must get filtered.

- Likewise for the other 2 tables as well.

This is a critical assignment and I need help asap ! Screenshots of the table are inserted below :-

Thank you !

[inderz]

The relationships look like :-

The Report is shown below. While the Main Table visual can do a 2-way filtering between the other 3 visuals, the other 3 cannot filter amongst each other !

[parry2k]

Could you explain what didn't worked?

Lets' take an example here, your top right bar graph, when user click on it, you want no bottom graphs get filtered.

to achieve this:

- click edit interactions, under Format Tab

- select top right corner graph, other graph will show icons on top

- click no filter icon on bottom two graph.

[inderz]

What I need is, top right graph once clicked should filter the bottom two graphs. And if I click on any of the bottom 2 graphs, the other grpahs should be filtered.

I have done this on one table data, but somehow no luck in a multiple table situation.

Regards

[parry2k]

I get it now, so how these tables are connected. Also can you make your relation to "single direction" instead of both. 

[inderz]

Yup ! the issue is the relationships.

Single-way will not help as with both-ways, I could get the other graphs to filter the top-left graphm which is the central table to which other 4 tables are related.

Please have a look at the Excel file.

[inderz]

Would request all experts to help me solve the issue with the help of the Excel file uploaded by me above.

Will be extremely grateful.

regards

Inder

[v-ljerr-msft]

Hi @inderz,

The link for your shared file is not available to me. Could you upload it to OneDrive or Dropbox and post the link here? Do mask sensitive data before uploading.

Regards

[inderz]

Hi @v-ljerr-msft,

Thank you so much for the help.

The file is on OneDrive at https://1drv.ms/x/s!AtBpRPt_tNIRiX1XHZNQ20PeLbdd

Regards

Inder

[parry2k]

Can you share how these tables are related? And if possilble, can you send some sample data and I can create an example report for you.

[inderz]

Sure ! Thank you for the help. I will upload the file asap. How do I attach the Excel file ? 

Regards

Inder

[inderz]

Here is the Excel file...link 

https://ufile.io/f20b3

Thank you.

[parry2k]

Bud, did you tried visual interactions?

[inderz]

Please see this.

[parry2k]

It is easier than I thought. I don't need file. You need to use "Edit Interactions" between visual, you can decide what should happen when a user click on one of the graph, should it filter others, slicer or no filter.

here is more information on how to set up interaction between visuals:

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-visual-interactions/

https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-3-11a-create-interaction-betwee...

Feel free to reach out if you need further help.

Cheers,

P

[inderz]

Dear Parry,

Thank you I did try but alas.

I have included the Report screenshot. I wish to upload the Excel file...but haven't figure out how to !

Regards

Inder

[parry2k]

@inderz I don;t think I need excel sheet, you just need to work with Visual INteraction, do you need help with that? Did you already tried setting up interactions between visuals?

[inderz]

Yes Parry, I did....didnt help.

Have uploaded the file. Would appreciate your expert guidance !

regards

Inder