Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |