Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Scatter Chart Problems

Hello,

 

I have a data for a contractor, project,, Project type, actual progress and date

The date I have for four months Jan, Feb, March, April then I have actual progress percentage for each project and next to it the contarctor. I want to create a scatter chart which I can play the months and in the x axis will show the projects names, and the y axis shows the progress to play how much progress the contractors are doing over time. When I try to build the chart I get the followin

 

13 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support

    Hi Anonymous ,

    Try to show like this:

     

    Best Regards,
    Yingjie Li

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for your replay. If I want to show it the same way as you suggested then I will lose the biggest benefit of the scatter chart which is showing the progress changes over time through the play axis.

      The three axises that I need are:

      The project name x axis 

      The progress percentage on Y axis

      The month on the play axis.

  • stevedep's avatar
    stevedep
    Memorable Member

    The X and Y values need to be numeric in a scatterplot. 

    Hope it helps.

    Kind regards Steve

    • Anonymous's avatar
      Anonymous
      Not applicable

      stevedep  I tried a lot of different options but nothing worked so far. 

      • stevedep's avatar
        stevedep
        Memorable Member

        The date column is a text field? These cannot be played. Can you make it a date or a number?

  • The problemthat I am  experiencing is that on my powerbi desktop, the details facility does not exist.Can anyone help me?