Forum Discussion
How to filter multiple visuals based without doing it on every visual seperately?
Hello,
i'm learning the basiscs for Power BI and want to start making some reports to use in real life.
My question is now on how best to approach this report:
I have an SQL view wich contains all items to reorder together with current stock, sales orders, saleshistory of past seasons to calculate estimated period that our current stock might last.
Al those things are gathered and precalculated on in that view.
Now i'm making a report in Power BI to highlight only those items where estimated time that current stock will last is lower than 3 months.
So i pulled in the view into Power BI and made a table to display only those articles without sufficient stock.
i did this by adding a filter to the visual on the filter pane to only show the articles with "months left" lower then 3.
But then started to think about also adding a KPI card to count those articles and an matrix to count the number of references by category.
I could also add the same filter for those visuals through the filter pane, but what if a want to change the number of months to look at from 3 to 4.
i need to change the filters in all those visuals?
Is there a better way to handle this?
thanx!
Chris
Chris_Cools , if you added a slicer in a report page it will affect all visuals automatically, so when the user use this slicer the data will be affected on all the visuals.
4 Replies
Hello Chris_Cools ,
so instead of adding the filter in the "for this visual" in the filter pane, add it for the "filters on this page" which will affect all the visuals in the current page. And there's also an option for filter on all pages in the report, in case you wanted to add a filter that would affect all the pages.
Hello Idrissshatila,
Thank you for this answer and i'll try this!
But what if i want to make this adaptable by the user with a slicer to select the number of months to take into account?
Would i still need to proceed like this?
Or take a different route?
Kind regards,
Chris
Chris_Cools , if you added a slicer in a report page it will affect all visuals automatically, so when the user use this slicer the data will be affected on all the visuals.
thanx very much!!
