Power BI
NewIncrease limitation on number of series/cateogry/legend entries for charts from 60
James Sterling on 12 May 2021 17:01:35
Currently the maximum number of series/category/legend entries is 60. The maximum number of series in a pivot chart is 255, so this is actually a downgrade from excel.
In my example I am creating a stacked bar chart with individual scrap quantities. There are many different categories which scrap can come from, so I need much more than 60 to see my total quantity for each lot of parts. I know a limitation of 60 series/category/legend entries creates issues for customers dealing with large, complex data sets as I have seen multiple posts on the forum about this limitation.
Even if there is no way to remove this limitation, a pop up error box like excel generates for more than 255 series would at least make the report creator aware not all data is being shown.