topic Re: Funnel chart – how to display more than one value? in Custom Visuals Development Discussion

Funnel chart – how to display more than one value?

mkmarcelo — Tue, 05 Aug 2025 14:04:38 GMT

ENG

Hi everyone,

When using the native Power BI funnel visual, we typically add the category (e.g., stages of a sales funnel) and a measure in the values field. However, I often need to display more than one value, such as the number of opportunities at each stage and the average ticket value for those opportunities.

I know it’s possible to add the average ticket to the tooltip, but users often want to see both numbers directly on the visual without hovering. In horizontal bar charts, we can customize the data label to show the value and series detail, as well as adjust label positioning.

I’ve tried various funnel visuals, but I would like the native funnel chart to offer more flexibility in customization, similar to other visuals that have evolved over time. Does anyone have a tip or workaround for this? If not, I’d like to submit this as a feature request.

Thanks!

PT

Olá, pessoal,

Ao trabalhar com o visual de funil nativo do Power BI, adicionamos a categoria (por exemplo, etapas do funil de vendas) e a métrica em valores. No entanto, muitas vezes preciso mostrar mais de um valor, como a quantidade de oportunidades em cada etapa e o ticket médio dessas oportunidades.

Sei que é possível colocar uma segunda medida na dica de ferramenta, mas os usuários costumam querer ver ambos os números diretamente no gráfico, sem precisar passar o mouse. Em gráficos de barras horizontais conseguimos personalizar o rótulo para exibir o valor e o detalhe da série, além de ajustar a posição desses rótulos.

Já testei vários visuais de funil, mas gostaria que o visual nativo oferecesse mais opções de customização, assim como acontece com outros gráficos que evoluíram ao longo do tempo. Alguém tem alguma dica ou solução alternativa? Se não houver, deixo aqui a sugestão de melhoria para futuras versões.

Obrigado!

Re: Funnel chart – how to display more than one value?

johnbasha33 — Wed, 06 Aug 2025 15:42:57 GMT

Hi @mkmarcelo

What You Can and Can’t Do with the Native Funnel Visual

✅ You Can:

Display one measure per category (stage)
Show one number as a data label (the value in the Values field)
Add additional metrics to the tooltip

❌ You Can’t (as of now):

Display more than one measure directly in the funnel visual
Customize data label content beyond the primary value

Workarounds

🔹 1. Use a Custom Funnel Chart Visual

If you're open to custom visuals, check these from AppSource:

“Funnel Plot by MAQ Software”
“Funnel Chart by xViz” – allows multiple metrics and advanced labeling
“Advanced Funnel” by ZoomCharts

Some support:

Multiple KPIs side-by-side
Rich data labels
Formatting like tooltips, progress bars, and interactivity

⚠️ Be cautious with licensing (some are freemium).

2. Stacked Bar Chart Alternative

If exact funnel shape isn’t essential, a horizontal stacked bar chart gives:

More control over labels

Ability to place both “count” and “avg ticket” as separate measures

Flexible tooltips, legends, and color rules

You can even simulate a funnel-like visual by sorting stages and formatting bars to taper visually.

3. Overlay Labels with DAX & Shapes

For static reports:

Create DAX measures for each value (e.g., count, avg ticket)

Use a matrix or card visual aligned next to the funnel to simulate multi-metric labels

Or manually position textbox overlays if the data is static (not ideal, but works in a pinch)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Re: Funnel chart – how to display more than one value?

mkmarcelo — Mon, 11 Aug 2025 13:56:38 GMT

Hello @johnbasha33

I understand the usability of the native funnel and the alternatives when using a custom funnel chart.

I already use a bar chart as a custom funnel, but the custom funnel visuals are paid and we don’t have a budget for that.

This situation might happen to more people, and it would be interesting for the Power BI team to consider the possibility of applying improvements to the native funnel chart.

Re: Funnel chart – how to display more than one value?

andrjohns — Wed, 13 Aug 2025 04:00:15 GMT

Hi @mkmarcelo, we have a free (and open-source!) funnel chart visual that you could try here: Funnel Charts

The next version of the visual (currently under review by MS) supports labelling individual points:

You can also try out the functionality before it's released by downloading the development version of the visual from here and importing into your report using the 'Import Visual from File' option

Hope it helps, and feel free to reach out or open issues on the Github repo if you have any feature requests (or run into bugs!)

topic Re: Funnel chart – how to display more than one value? in Custom Visuals Development Discussion

Funnel chart – how to display more than one value?

Re: Funnel chart – how to display more than one value?

What You Can and Can’t Do with the Native Funnel Visual

✅ You Can:

❌ You Can’t (as of now):

Workarounds

🔹 1. Use a Custom Funnel Chart Visual

2. Stacked Bar Chart Alternative

3. Overlay Labels with DAX & Shapes

Re: Funnel chart – how to display more than one value?

Re: Funnel chart – how to display more than one value?