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,

 

Thanks a lot for your response!! Actually i want to filter with Table_name, date(Audit_Capture_Date in my report) columns and see the trend in my report.Eg: for the date 12/1/2018 like the way u mentioned along with 3 entries for the tables a,b,c there can be one more record for table 'a'  on the same date 12/1/2018.Can I use the index column in this case as well? My report looks something like below.

 

Also, i will use the index column in x-axis  but don't want to display the index values 0,1,2 etc in the line chart.Is there any way to achieve this, pls let me know.

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

Hi Anonymous,

 

As I mentioned previously, the line chart visual is used for display aggregated values instead of raw data. 

 

In your scenario, if you would like to display three data points for the same X-axis value, the workaround is add another column in X-axis (eg: index column) to distinct records within the same date. The index column is not able to hide after putting this column in x-axis. 

 

Best Regards,
Qiuyun Yu

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Qiuyun,

     

    Thank you for your response.Other than line chart, is there any other chart/visual that can be used where i can achieve my requirement without using index column.

     

    Thanks.

      • 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  : )