Forum Discussion
Helper IRow limit in Hierarchy slicer's search function
Hi JayV ,
There are different types of slicers in Power BI, each with its own limitations. The Hierarchy slicer has a limit of 30,000 rows. You can experiment with different types of slicers, such as drop-down list slicers or list slicers. These slicers have no row limit and can display all data.
If you want to limit the number of options displayed in a slicer based on another slicer selection, you can use a custom visual object, such as OKVIZ's Smart Filter Pro. This visual object searches for multiple columns of data at once and has an unlimited row limit.How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi JayV ,
There are different types of slicers in Power BI, each with its own limitations. The Hierarchy slicer has a limit of 30,000 rows. You can experiment with different types of slicers, such as drop-down list slicers or list slicers. These slicers have no row limit and can display all data.
If you want to limit the number of options displayed in a slicer based on another slicer selection, you can use a custom visual object, such as OKVIZ's Smart Filter Pro. This visual object searches for multiple columns of data at once and has an unlimited row limit.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.