topic Add Total Row to Funnel Chart in Power Query

Add Total Row to Funnel Chart

Anonymous — Mon, 25 Nov 2019 22:19:18 GMT

Hello,

I have a funnel chart showing the count of each task by stage:

My data is as so:

Task Stage

Task 1 1

Task 2 1

Task 3 3

Task 4 2

Task 5 2

I'd like to add a row to the top of the funnel chart that has a total count of all Tasks.

I have tried making new measures counting all rows in Stage column, but I am not sure how to add that measure to this chart.

Surprised this functionality isn't already built into the funnel chart.

Can anyone help guide me on this?

Re: Add Total Row to Funnel Chart

v-juanli-msft — Tue, 26 Nov 2019 08:42:25 GMT

Hi Anonymous

As said, it's impossible to show Total as a bar in Funnel chart.

You can only summarize total into a new row and union it into existing table,

Then populate the new calculated table into the Funnel chart.

https://community.powerbi.com/t5/Desktop/Select-all-Total-in-funnel-chart/td-p/184008

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.