Forum Discussion

johnbasha33's avatar
johnbasha33
Super User
1 year ago

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

 

mkmarcelo's avatar
mkmarcelo
New Member
1 year ago

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.

  • andrjohns's avatar
    andrjohns
    Helper II
    1 year ago

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