Forum Discussion
Pivot fields to filter visual
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 candidate
2- 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.
14 Replies
fernandoC ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi amitchandak ,
Thank you for your help!.
Please find the pbix file here: File
The main information is located on the table "Link Main Info" table.
Any other questions or doubts please let me know.
Best,
- can you share some sample data?
Hi vanessafvg ,
Thank you for your help on this!.
Sure, I just uploaded a file in Drive on my previous message.
Please let me know if you can access it.
Best,
Was the file accesible for you?.
Please let me know if further information is required.
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.
Hi vanessafvg ,
You gave me a great Idea. At the end I was able to merge the issue link table and connect them with the 'candidates' data on the Source ID and the 'Offers' ID for the Destination ID. That gave me the option to filter by both Offer Resolution and to have the Source information in the same row.
Theres four hires and the results show 4 total sources which resolves the issue.
Thanks again for all your help.
Best,
- well done!
