The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I've been trying to figure out my problem for over a week now. I really need some help.
I have a page in my Power BI that looks like THIS. It contains all of my slicers.
I have a line charts and tables that look like THESE.
I have a table structure that looks like THIS.
You can download my report file by clicking HERE.
I need the following:
1) When I change one slicer they should all update. For example, if I select a Project the Job Role, Resource, Pipeline Step, Project Type, Business Unit, Date Range and FTE Range should also change. I can only make this happen if I put all the data in one large table. The problem is, I can't put all the data in one table. I need the table ending in PLN and the table ending in AVL to be seperate.
2) When I change one of the filters, for example resource, I need the tables and chart to change. Under the table named Count of Resources I need the proper count from the Master Filtered PLN and the Master Filtered AVL tables. I need the line charts to also update. I can only make this work if I use the tables Calendar, Roles, Resources, Hour Types, etc. to make my slicers but then the slicers don't sync.
In other words, I need all the slicers to filter one another and I also need the right data to be displayed from two different tables. I can't make them both work. Can someone help? Please?
Solved! Go to Solution.
@Anonymous , I opened the file. And most of the time I see only one slicer. And visuals are getting filtered from it. So not very clear on the GAP
If you have two slicers from dimension and want to filter each other - https://www.youtube.com/watch?v=cyOquvfhzNM
Sync slicer across page - https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages
@Anonymous , I opened the file. And most of the time I see only one slicer. And visuals are getting filtered from it. So not very clear on the GAP
If you have two slicers from dimension and want to filter each other - https://www.youtube.com/watch?v=cyOquvfhzNM
Sync slicer across page - https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicers-on-other-pages
The video was exactly what I needed. Thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
261 | |
120 | |
113 | |
83 | |
71 |