Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
mkmarcelo
New Member

Funnel chart – how to display more than one value?

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!

3 REPLIES 3
johnbasha33
Super User
Super User

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 !!

 

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.

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: 

andrjohns_0-1755057405331.png

 

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!)

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors