Funnel Comparision

[Sandeep_1992]

Hi Everyone, I have created this funnel using python - But, its not interactive with the other graphs... Any solution to make it interactive 

Second, I wanted to compare Funnel with 2 different values like Opportunity count this year and last year - But, Last year opportunity count only the difference shows in the extended BARs for eg:- Green shows improvement , Red Show reduced count ( Do we have any solution where same can be achieved with any visuals in power bi So, that it can be interactive

[v-hashadapu]

Hi @Sandeep_1992 ,
I hope the information shared was helpful. If you have any additional questions or would like to explore the topic further, feel free to reach out. If any of the responses resolved your issue, please mark it "Accept as solution" and give it a 'Kudos' to support other members in the community.
Thank you!

[v-hashadapu]

Hi @Sandeep_1992 ,
I wanted to follow up and see if you’ve had a chance to review the information provided here.
If any of the responses helped solve your issue, please consider marking it "Accept as Solution" and giving it a 'Kudos' to help others easily find it.
Let me know if you have any further questions!

[Sandeep_1992]

I'm Fine to use custom funnel as well - (wecan compare year over year) but, it should interact with dashboard like if i slice it using region funnel should show values for that region

[burakkaragoz]

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.

[burakkaragoz]

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:

1. Use a clustered bar or column chart instead of a funnel visual — this gives you more flexibility to compare values across categories.
2. 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.
3. 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.

[Sandeep_1992]

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 

[burakkaragoz]

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:

1. 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.
2. 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!