Issue with bar gauge

Hi,
I want to create a bar gauge to monitor my windows services but when i have more than 50 rows, i dont the the row 51, i have try to set limit to 5000 but that doesn’t work.

If anyone have the same issues,

my query=

from(bucket: v.bucket )
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "win_services")
  |> filter(fn: (r) => r["_field"] == "state")
  |> last()

Thanks,
Mike

I have a good news for you. We are releasing Grafana 7.4.1 today that comes with possibility to configure the max series (with default set on 1000). For more info, see https://github.com/grafana/grafana/pull/31025