Forum Discussion
Pivot fields to filter visual
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 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!