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 pro...
Need Help
stevedep's avatar
stevedep
Memorable Member
6 years ago

Hi,

 

Since the scatterplot any accepts 2 numeric values, one for the x-axis and one for the y-axis. You are probably looking for a different (custom) chart like, 'Animated Bar chart race', which animates bar charts. As seen below:

 

Power BI file

 

Hope it helps. Pls mark as solution if so, thumbs up for the effort appreciated.

 

Kind regards, Steve. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

stevedep 

I wanted something like the video attached but instead of total sales it will show the projects name and instead of sales units it will show the progress ...

 

  • stevedep's avatar
    stevedep
    Memorable Member
    6 years ago

    In that case you need to create an artificial x-value:

    Then you can play the results for the y-value, colour by project name. 

     

    Link to Power BI file here. 

     

    Please mark as solution if this helps you. Thumbs up for the effort are appreciated.

    Kind regards, Steve. 

    • stevedep's avatar
      stevedep
      Memorable Member
      6 years ago

      Please let us know if this works for you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        stevedep  no it did not unfortounitly. It wasted so much time, so I gave up making it.