Forum Discussion

Gnanasekar's avatar
Gnanasekar
Icon for Helper III rankHelper III
9 years ago
Solved

Select all/Total in funnel chart

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

Need Help
Tips and Tricks
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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,