Forum Discussion

alexsenso's avatar
alexsenso
Regular Visitor
6 years ago

Relation Issue (I Think)

Hi, 

Im trying to im having an issue pulling the correct Figures for opportunities from Dynamics 365 i have modified the salesmanager.pbix with some sucess but i have a custom field which is an option set (opportunity type)  that i have loaded, I have then added a conditonal column so the guid is not used and i have a readable output, such as new business etc. 

 

This issue i have is that i see the readable output but the figures are all the same and not split as an amout  per Opportunity. Please see below link? Any pointers as to whats happening i think its to do with the opportunities I have loaded and the Opportunity table that already exists within the salesmanager.pbix. and their relationships? 

 

Thanks

 

this link is a screenshot of the visual for context

 

Link To Screenshot 

 
 

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support

    Hi alexsenso ,

    The link is not effective. Can you please share a new one? Or you could share some pics directly. Then we will understand clearly about your problem.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • alexsenso's avatar
      alexsenso
      Regular Visitor

      Hi,

      Thanks for the reply. 

       

      Heres a new picture.