u/Fluid_Can8875

Hi everyone,

I'm building an NPS dashboard in Power BI with a line and stacked column chart:

- Columns: number of survey respondents per month

- Line: NPS score for that month (secondary Y-axis)

I have two slicers: cluster (segment) and survey name. The problem is that respondent volume varies drastically between clusters:

- Financial segment: 10k+ respondents per month

- Other segments: 200-300 respondents per month

If I set a fixed Y-axis range that works for low-volume surveys, the columns overflow and cover the NPS line when filtering

high-volume ones. If I set it for high-volume, the columns become nearly invisible flat bars when filtering low-volume surveys.

Is there a way to make the Y-axis range adjust automatically based on the slicer selection, so the chart always looks balanced regardless of which cluster or survey is filtered?

Any approach is welcome — DAX measures, visual settings, custom visuals, or a completely different chart design. I'd rather hear the best practice than force a solution I already have in mind.

Thanks!

Everyone talks about MRR on Twitter and LinkedIn, but almost nobody shares the real numbers. No fake guru stuff, no edited screenshots, no hype.

How much money has your SaaS actually made so far?

Could be profit, revenue, a side project, or even $0. Also share what your SaaS does, how long you’ve been working on it, and what the hardest part has been.

Todo mundo fala de MRR no Twitter e LinkedIn, mas quase ninguém mostra os números reais. Sem hype, sem pitch de vendedor, sem print editado:

Quanto você já ganhou de verdade com o seu SaaS?

Pode ser lucro, faturamento, side project ou até zero reais ainda. Conta também quanto tempo levou, o que o SaaS faz e qual foi a parte mais difícil até agora.