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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Stupid me, sorry kohlivinayak, I talked until now about scatter plot while I am working with line chart...

       

       

      I think what differs my report from yours is the data to use for values for line chart: I am working with a DirectQuery from SQL Server database and I am using "Count of column_name" as value. Then I work with filters, which make months with no data disappear, while your month names are fixed, stable. I think working with filters bothers me, I'd need that when you filter data you don't lose data with no values, because no values should mean 0.

      • kohlivinayak's avatar
        kohlivinayak
        Resolver I
        8 years ago

        No Issues case in scatter and line chart don't vary much.

         

        So why mine is stable i have created a new table having the values of month. Created a relation with actual data table, and will create filter from this table

         

        Table 1 ---> Actual Data

         

        Table 2 (need to be created) ---> Only Month Name/ Month Year Name eg [1,2,3,....,11,12]

         

        Create a relation between these two ( single side filter from table 2 to table 1 )

         

        Create the filter on Table 1 - so that when you filter the table, table 2 values will not be affected, hence measure will be calculated for all the values.

         

        If your filter filters out the values in table 2 you will not see those months hence no zeros.

         

        Thanks

        Vinayak