Search code examples
powerbidaxdashboardpowerqueryslicers

How many values a slicer can hold?

In power bi how many values a slicer and hierarchy slicer visual can hold.Recently in one of the dashboard i used a hierarchy slicer for one field , where field contains 169k distinct values. Problem is slicer is not show all values and performance wise it is slow

Thanks, B

Solution

  • Assuming you're talking about this visual: "Hierarchy Slicer" from App Source

    https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?mktcmpid=Pickitli&tab=Overview

    enter image description here

    Understand that 'number of rows/items' is rarely a specified limit in PowerBI. The limiting factor is the memory of the machine running the report. At some point, things just slow down past usability.