Select all/Total in funnel chart

[Gnanasekar]

Hi All,

How can I get select all\ Total in funnel charts?

Data columns  like:

Product : Quantity

A           : 586 

B           : 361

C           : 159

D           : 83

(It is not 4 rows data. here I given aggregate value only)

Here I want show total in funnel chart. How can I show ? 

I don't need make measure here. Any other way to get total here?

By

Gnanasekar

[v-sihou-msft · Accepted solution]

@Gnanasekar

No, it's not possible to show Total as a bar in Funnel chart. You can only summarize into a new row and union it into existing table. Then populate the new calculated table into the Funnel chart.

Table = UNION(SUMMARIZE(Table1,"Product","Total","Quantity",SUM(Table1[Quantity])),Table1)

Regards,