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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous

 

I downloaded you file and learned what you mean, but when I try to do it in my own file with my SQL Server database (not SSAS), the column is created but it shows "this step creates a query which is not supported in Direct Query mode".

 

Nick

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous，

What is the data type do you set for your columns in SQL Server database?

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous，

    In this case, you would need to create the Month name column and Month no column in SQL data source.

    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous

     

    The data type for the column with dates in SQL Server is datetime. If I use "Add new column" in Power Query as you did in your file, using Text.Start(...), it returns the message I wrote in my previous message.