Issue with chart-col series when selecting top X values.
I recently implemented a chart using a slice that filters data using this statement:
IN([Team #], TOP(ORDERBY(Summary[Team #], [Delivery Success Rate]), 10))
I then updated the chart to show 3 fields side-by-side for each Key.
Initially the chart looked great.
But after performing a save/sync the chart looks like that in the image below.
The backing data (second picture) looks good.
It appears the col series chart is trying to insert data points for each non-existing key between the existing Key values.
The columns that show chart values seem to be correct just a bunch of bogus chart values in between.
switching to row series is fine.
attempts to create a sheet that serves up the Top 10 and by passing the TOP(ORDERBY()) statement above DID NOT solve the problem. 3) Having the chart reference a Slice that DOES NOT have the TOP(ORDERBY()) seems to work fine.
I had to remove this chart for now.
Any ideas what is going on??