cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mkranitz Frequent Visitor
Frequent 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 Felix


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

Proud to be a Datanaut!




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 Felix


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

Proud to be a Datanaut!




View solution in original post

mkranitz Frequent Visitor
Frequent 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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors