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

NOOB question - How to dynamically update other visualizations with slicer

Hi guys, my first post (of many to come!) in this community. Grateful in advance for help with what is probably a simple request!

 

I'm trying to accomplish something that is visible in spades in this demo: 

 

https://community.powerbi.com/t5/Data-Stories-Gallery/Retail-Analysis-Dynamic-Measure-amp-TopN-Selec...

 

If I click on any month in the main visual (the one showing all the months of sales/profit/returns), then the visualization named "Top X stores by..." dynamically updates the list of stores.

 

I'll set the table:

 

I have a single data source called "Tickets". It's a .csv that was exported from our ticketing software. It has every ticket submitted by every one of our customers. (we are a tech support company). I have no other tables, no other relationships yet. I'm under the impression that this might change based on your answers!

 

I have a page that has the following:

 

  • A slicer that holds the customer name that I use to choose which company the page will provide visualizations on
  • A clustered column visualization that shows the number of tickets opened by month (I just dropped the ticket number field onto the page, then dropped the [date opened] field on it, set to display only by month. This shows every month that tickets were submitted.
  • A stacked bar visualization for the "top 5 requestors" that show the top 5 (five is fine as a static value) requestors - who were the folks who made the most requests.
  • A clustered column visualizatoin for the "top 5 closers", showing which engineers closed the most tickets.

 

The page works fine off the bat... It shows all the proper metrics. Where I need help is here:

 

When I click on a month, the other visuals don't update with the top 5. It just keeps the current 5 in place and then adjusts to show how many tickets those 5 closed.

 

What I want to happen is for the top 5 in both visualizations to dynamically adjust to show the top 5 for that selected month.

 

2018-09-13 11_26_29-AMH Dash - Power BI Desktop.png

Help me, Obi Wan! You're my only help...

 

Thanks for helping this hungry noob eat!

 

Mitch

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: NOOB question - How to dynamically update other visualizations with slicer

Hi @mkranitz,

 

Believe that what you need is to edit the interactions between your charts, you are making a highlight interaction so the TOP 5 will keep the same only showing what percentage of the month selected represents in the full year. If you select the interaction to be cross filter then you will get the change of the TOP 5.

 

Check the documentation on how to achieve this and and example I have made:

 

interactions.gif

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


View solution in original post

2 REPLIES 2
Super User III
Super User III

Re: NOOB question - How to dynamically update other visualizations with slicer

Hi @mkranitz,

 

Believe that what you need is to edit the interactions between your charts, you are making a highlight interaction so the TOP 5 will keep the same only showing what percentage of the month selected represents in the full year. If you select the interaction to be cross filter then you will get the change of the TOP 5.

 

Check the documentation on how to achieve this and and example I have made:

 

interactions.gif

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Check out my blog: Power BI em Português


View solution in original post

mkranitz
Regular Visitor

Re: NOOB question - How to dynamically update other visualizations with slicer

That's the ticket! SUPER EASY! Many thanks for pointing me in the right direction.

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.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

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