Forum Discussion
Funnel Comparision
If you're okay with a custom funnel, you can totally build one using a stacked bar chart or matrix visual with DAX measures. The key is to make sure your measures are filter-aware, like this:
FunnelStage1 = CALCULATE( COUNTROWS('YourTable'), 'YourTable'[Stage] = "Stage 1" )This way, when you apply a slicer (like Region), the funnel will automatically update to reflect just that region’s data.
You can then place each stage as a separate measure in a stacked bar or matrix to simulate a funnel layout — and it’ll stay interactive with the rest of your dashboard.
translation and formatting supported by AI
Hi Sandeep_1992 ,
If you're trying to compare two funnels side by side (like different time periods, regions, or user segments), here are a couple of ways to do it:
- Use a clustered bar or column chart instead of a funnel visual — this gives you more flexibility to compare values across categories.
- If you really want to stick with funnel visuals, you can create two separate funnel charts and place them side by side in the report.
- Another option is to use Bookmarks or Field Parameters to toggle between different funnel views dynamically.
Power BI’s native funnel visual is a bit limited for comparisons, so sometimes a custom visual from AppSource or a workaround with bar charts works better.
Let me know what exactly you're comparing — I can help mock up an example if needed!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI
Thanks for your message... to confirm you ( Clustered bar chart - I have already created a funnel comparision for both the years but, its not what i'm looking for )
Let me make you understand it better : I have funnel where i have values for 2024 and 2025... Now i want to show both in funnel like the visual i share i want that exactly same like below are the values - My funnel top value show 300 it is increased by 50 from last year so, some light green bars both sides like 25 and 25 to show the improvement and red bars where we have negative value compared to previous year...
| Stage Order | Funnel Stage | Last_Year | Current Year |
| 1 | Need | 250 | 300 |
| 2 | Investigate | 200 | 250 |
| 3 | Evaluate | 180 | 120 |
| 4 | Compare | 150 | 100 |
| 5 | Decision | 120 | 140 |
| 6 | Won | 100 | 80 |
| 7 | Loss | 50 | 90 |
I don't know if its even possible or do you have any other way to compare funnel apart from side by side funnel or using stacked column chart bcy i have already tried that it doesn't produce results what i wanted
If you're looking to compare two segments (like different years or categories) within the same funnel, Power BI’s native funnel visual doesn’t support that directly — it only shows one series at a time.
Here are a couple of workarounds:
- Use a bar chart instead of a funnel — you can stack or cluster the bars by year or category, and it gives a similar visual flow.
- Or, create a custom funnel layout using shapes and measures in a matrix or stacked bar chart — it takes a bit more setup but gives you full control over how each segment is displayed.
If you're open to using custom visuals, there are some on AppSource that support multi-series funnel comparisons.
Let me know what kind of comparison you're trying to show (e.g. year-over-year, region vs region), and I can help mock up a structure for it!