The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Hi @mkmarcelo
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
Display more than one measure directly in the funnel visual
Customize data label content beyond the primary value
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 !!