Add Total Row to Funnel Chart

[Anonymous]

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? 

[v-juanli-msft · Accepted solution]

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.