Forum Discussion
Power Bi Dropdown List Slicer
Hello,
You can consider improving performance by breaking out the slicers into categories. So for example, you can instruct your end user to first select an "Industry" slicer (e.g. banking, professional services, etc.) and have that slicer filter down the customer slicer into something more manageable.
Hi Nila ,
Your 4 million rows of data may be too much for Power BI, which is the main reason for your slow query. If your connection mode is Import mode, I suggest changing it to DirectQuery mode if possible, so that the query can be passed to the data source for better query capabilities. If you are already in DirectQuery mode or you cannot convert the connection mode to DirectQuery, then I think the only effective way is ExcelMonke's method, and the effect of other methods may be minimal.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.