Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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 , 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"))
Thanks Amit. I did not think of that we can use all values and group can be blank for funnel. It worked.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |