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!

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

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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