Hi! I'm trying to create a pie chart that counts the source of a candidate 'only' if it has been hired. To do this there's two steps in the process: 1- That the 'Offer Resolution' column is = "Accepted", LinkName = OfferedBy - Offer for candidate2- That there's a link between the Offer and the candidate on point #1 as the candidate is the one that contains the "Source" field. I would like to have 1 row that contains both the source info and the accepted status. Not sure if it can be achieved by using a column pivot. If additional information is required please let me know. Best,

hi this is not the most elegant solution, i would probably try and merge them in power query but since i dont have access to the source file what i have done is created a new table called offer accepted, and filtered that only on accepted offers. I then join that back to link main info on the destination id = source id (look in the relationship view how i have joined them) and then created a measure that does that join with the conditions. im sure there is a better way to do this but it works.

Pivot fields to filter visual | Microsoft Fabric Community

Forum Discussion

14 Replies

Related content