Create group from multiple columns for funnel chart

[lokeshb31]

Hello Experts,

We have a requirement to display Applicants, Interviewed candidated, offered and Hired ones in funnel chart in our organization. 

All Hired candidates are interviewed and offered, all offered candidates are interviewed but may not be hired and all interviewed candidates may or may not be offered/hired. This data need to be grouped in funnel chart. Please help to achieve this. 

[amitchandak · Accepted solution]

@lokeshb31 , In funnel visual you can use all measures. Do not add group

examples

Applicants = count(Table[candidate_id])

Hired= calculate(count(Table[candidate_id]), filter(Table , Table[Hired] ="Yes"))

Interviewed = calculate(count(Table[candidate_id]), filter(Table , Table[Interviewed] ="Yes"))

offered = calculate(count(Table[candidate_id]), filter(Table , Table[Interviewed] ="offered"))

[lokeshb31]

Thanks Amit. I did not think of that we can use all values and group can be blank for funnel. It worked.