Forum Discussion

fernandoC's avatar
fernandoC
Helper V
5 years ago
Solved

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 =...
Need Help
Show and Tell
  • vanessafvg's avatar
    vanessafvg
    5 years ago

    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.

     

     

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago
can you share some sample data?
  • fernandoC's avatar
    fernandoC
    Helper V
    5 years ago

    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, 

    • fernandoC's avatar
      fernandoC
      Helper V
      5 years ago

      Hi vanessafvg amitchandak,

       

      Was the file accesible for you?.

       

      Please let me know if further information is required.

       

      Best, 

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        5 years ago

        hi yes the file was accesible, not really 100% what you asking for, i dont know if this answers your question, or do you want ot demonstrate what you expect the answer to be?