Forum Discussion
Funnel Comparision
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
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
6 Replies
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 AIThanks 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!
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
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 ,
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!
