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