Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Integer value column is summing up in line chart

Hi,   I have table in SQL with 3 columns Date,Table_name,no_of_records.For each date there will be 2 or 3 rows.When i'm trying to show this trend in power Bi i.e. no_of_records in y axis and date i...
Custom Visuals
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Qiuyun,

 

Thank you for your response! I'm using line chart to achieve my requirement but i'm facing a issue where the record count has been increased from 61 to 65 on the 3rd jan 2019, instead of displaying increasing curve in the line chart, it is displaying decreasing curve as attached.Could you please let me know how to rectify this.Also pls let me know how to refresh only the particular visual in the report.

 

 

Thanks  : )

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous,

     

    The line values depend on used raw data. You can change visual type to table visual, set Don't Summarize for the value which you set Count aggregation in the line chart. Manually calculate the count values to check if they are correct. 

     

    We can't refresh specific visual data in Power BI desktop, we can just refresh specific query table. If the query table is only by this one line table visual, you can right click the table to choose Refresh Data: 

     

     

     

    Best Regards,
    Qiuyun Yu