Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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:
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.
Help me, Obi Wan! You're my only help...
Thanks for helping this hungry noob eat!
Mitch
Solved! Go to Solution.
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:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThat's the ticket! SUPER EASY! Many thanks for pointing me in the right direction.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |