Forum Discussion
Funnel chart – how to display more than one value?
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 !!