Filtering and Searching is poor. Get this right and Power BI will be the best. But until you do. You need to start again to include - a powerful search option. Including using < > = etc - select mor...
And it should be possible to include these filters either on the sheet with the visualizations or on the side bar as required. And both should be totally integrated. So if a selection is made for a customer in say a table then this selection should also show in any other customer filter.
