topic Create group from multiple columns for funnel chart in DAX Commands and Tips

Create group from multiple columns for funnel chart

lokeshb31 — Sun, 14 Mar 2021 06:44:27 GMT

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.

Re: Create group from multiple columns for funnel chart

amitchandak — Mon, 15 Mar 2021 07:47:57 GMT

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"))

Re: Create group from multiple columns for funnel chart

lokeshb31 — Fri, 19 Mar 2021 08:45:09 GMT

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