Stacked Chart not showing all the Items of the legend

[Standef]

Hey everyone, 

I have many products that I am tring to display in two 100% stacked column charts.
One showing weekly info on the X axis, the other showing Daily. 

As you can see, the daily chart is not displaying allt he products that the weekly chart is showing, only half of them, although the only difference between the two charts is the X axis measure (The products sources is the same).

On the first chart,
the X axis is : Week Number = 'CALENDAR'[Year] & FORMAT(WEEKNUM([date],1),"00")

the Y-axis is : Count of Table[Name]

The Legend is : Table[Name]

On the second chart,
the X axis is : Daily_Date = 'CALENDAR'[MonthNum] & "/" & 'CALENDAR'[Day] & "/" & 'CALENDAR'[Year]

the Y-axis is : Count of Table[Name]

The Legend is : Table[Name]

Do you know if there is a maximum number of legend to be displayed at the same time on 1 chart in Power BI ? 

Or am I doing something wrong ?

Thanks a lot for your help! 

Stan

[lbendlin]

look for the blue "i" in the top right corner of the daily visual. click that.

[Standef]

Yep I've seen that I need to filter the data more because there is too many datapoints. 

When doing the same in Tableau I don't have this problem so I thought PowerBI could do it as well.. 😞

Do you know how I could group the little segments in an "Other" segment so that instead of trying to display the long tail of items not sold very often, it would only display a grouped segment for them ?

Thanks a lot,

Stan 

[lbendlin]

Search for instructions about "Top 3 and others". Plenty of examples all over the interwebs.