Forum Discussion
Add Total Row to Funnel Chart
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?
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.
1 Reply
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.