Forum Discussion

nicolast29's avatar
nicolast29
Helper V
4 years ago
Solved

Problem with scatter chart.

Hello, The scatter chart below is not depicting my expected results.    I would like that the Axe X respect the ordertime of the day   I  find how to  order by in the reght up coin but i have 8:...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi nicolast29 

     

    Download example PBIX file.

     

    The data has lots of blanks in it.  If you look at a matrix

     

    You can see where there are no values for certain combinations of nom and heure.

     

    When you plot this, it's messing up the scatter chart.  On the scatter chart Y-axis, you can turn on Show blank values

     

    Additionally, your Table_heure is missing a row for midnight.  I've added this in the file linked above.

     

    Regards

     

    Phil

     

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi nicolast29 

 

Download example PBIX file.

 

The data has lots of blanks in it.  If you look at a matrix

 

You can see where there are no values for certain combinations of nom and heure.

 

When you plot this, it's messing up the scatter chart.  On the scatter chart Y-axis, you can turn on Show blank values

 

Additionally, your Table_heure is missing a row for midnight.  I've added this in the file linked above.

 

Regards

 

Phil