[prometheus-kube-stack] Does not work with otel metrics

[Nessaek]

Describe the bug a clear and concise description of what the bug is.

I'm trying to use the latest version of kube-prometheus-stack to work with open telemetry metrics. However the http metrics include periods (.) by default. E.g a metric like http.server.request.body.size_bytes_bucket will error on prometheus - Error executing query invalid parameter "query": 1:5: parse error: unexpected character: '.'

I have tried to configure the chart to work with these values with no success. Is this a known issue or am I missing something?

What's your helm version?

version.BuildInfo{Version:"v3.18.2", GitCommit:"04cad4610054e5d546aa5c5d9c1b1d5cf68ec1f8", GitTreeState:"clean", GoVersion:"go1.24.3"}

What's your kubectl version?

Client Version: v1.31.4 Kustomize Version: v5.4.2 Server Version: v1.33.1 WARNING: version difference between client (1.31) and server (1.33) exceeds the supported minor version skew of +/-1

Which chart?

kube-prometheus-stack

What's the chart version?

latest

What happened?

I ran:

1. helm install prometheus-stack prometheus-community/kube-prometheus-stack
2. Sent metrics from a go project using otelhttp
3. Queried the metrics and got ``Error executing query
   invalid parameter "query": 1:5: parse error: unexpected character: '.'```

What you expected to happen?

The metric to be readable

How to reproduce it?

No response

Enter the changed values of values.yaml?

N/A

Enter the command that you execute and failing/misfunctioning.

``Error executing query
invalid parameter "query": 1:5: parse error: unexpected character: '.'```

Anything else we need to know?

No response