Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Scatter plot doesn't match points rightly

Hi,   my issue regards scatter plots. I have a scatter plot with months on x-axis and some integer numbers on y-axis. If I filter the data so that some month has no number (it should be 0, but actu...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous，

    Do you connect to SSAS database or SQL Server database in Power BI Desktop? If you connect to SQL Server using DirectQuery, you are able to use Query Editor in Power BI Desktop.

    Also please open updated PBIX file.

    Regards,
    Lydia

kohlivinayak's avatar
kohlivinayak
Resolver I
8 years ago

Hi Anonymous

 

Whatever calculations you are doing do it in a measure and add a 0 in the last eg

 

measure = sum(column_name) + 0

 

it will sove the problem.

 

Moreover I will personaly prefer a line chart with stroke width as zero and enable show markup to plot the points. With this i will be able to show names of the month

 

Thanks

Vinayak