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

Hi kohlivinayak and thank you for answering.

 

Unfortunately, it doesn't work. I created a measure adding 0 in the end but if I filter results the line still does not pass from 0 when it should.

 

Moreover I didn't understand what you mean with last sentence, starting with "moreover..."

 

Thanks

 

Nick

kohlivinayak's avatar
kohlivinayak
Resolver I
8 years ago

Hi Anonymous

 

I guess you are not using any relation and is taking date from the same table.

 

I have created a powerbi file, in the table on right bottom i have created the same thing twice onw with date dimension and one without date dimension. Depending on your requirement use the case which suits you.

 

https://drive.google.com/open?id=1SZI6NaUmsjWVQKyYMztPYUliCaqbsDr3

 

I hope it helps.

 

Thanks

Vinayak