cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Aaron
Regular Visitor

Multiple highlights across different visualisations

Hi

I am trying to replicate a functiion I had in tableau where I could select one item on different visualisations to drill in to the data.

 

eg selecting a Contact Reason filters the URL list and clicking on the URL list filtered the view to only those on both the Reason code and the URL.  

 

When i chose the Contact reason this works and when I CTRL click on the URL it just refilters on the URL.

 

Any thoughts

 

Aaron 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-huizhn-msft
Microsoft

Re: Multiple highlights across different visualisations

Hi @Aaron,

Please create a relationship between the visual by clicking Edit interactions under format on home page. Please select the button highlighted in red line, then it will be effected by other visual.

1.PNG

 

Best Regards,

Angelia

View solution in original post

5 REPLIES 5
Microsoft v-huizhn-msft
Microsoft

Re: Multiple highlights across different visualisations

Hi @Aaron,

Please select the URL column-> Data categories->Web URL. You can click it, it will jump to corresponding source.

 

2.PNG

Create a table visual to verify the result. Please see the screenshot below.

2.PNG
If this is not want you want, please share more details or sample data table for further analysis.

 

Best Regards,
Angelia

Aaron
Regular Visitor

Re: Multiple highlights across different visualisations

Thanks for the quick response.  

The below may better explain what I am trying to do.  What I want to do is highlight the reason code on the bubble chart and then the url on the bar chart and then see the other charts on the page just show the data that is both for reason code 12 and URL 17.

 

PowerBICapture.PNG

Hope this makes sense

Aaron

Microsoft v-huizhn-msft
Microsoft

Re: Multiple highlights across different visualisations

Hi @Aaron,

Please create a relationship between the visual by clicking Edit interactions under format on home page. Please select the button highlighted in red line, then it will be effected by other visual.

1.PNG

 

Best Regards,

Angelia

View solution in original post

Aaron
Regular Visitor

Re: Multiple highlights across different visualisations

Thanks for the response. I have tried this and do get the first chart to highlight but then cannot select an item on that chart to filter the rest of the visualisations as it resets the other view.

 

Guess thsi may just not be possible.

 

Aaron

ImportSJC
Regular Visitor

Re: Multiple highlights across different visualisations

For anyone in the future, what OP is describing IS possible with a ctrl+click. Unfortunately this feature is not obvious.

 

Documentation: https://docs.microsoft.com/en-us/power-bi/desktop-multi-select

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors