Forum Discussion

thom_vee's avatar
thom_vee
Frequent Visitor
8 years ago

Cumulative growth histogram

Hi All, I just got introduced to Power BI and have been testing it out. I`ve been creating some visualisations using it.  I have a table called observations , in which I have a column called "creat...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

My guess is that some dates in the Created on column are not actual date entries.  I'll need to see your underlying Excel file.  Please share the download link of that.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    I cannot download such a heavy file.  Share with me only that much data in the Excel file which you shared in your PBI file.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    There are text characters appearing in the Created_on date column of the "observations_stats_17_09_2013" worksheet.  Till as long as they remain, the relatioship will not work.  So clean that data first, remove the other worksheets of the workbook and share data for the same period as you have in your PBI file.

  • thom_vee's avatar
    thom_vee
    Frequent Visitor
    8 years ago

    From what I shared are you able to see any text characters? Can you give me an example? I`m lost as to what to look for among the big data rows.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    No, i cannot because there is no way t filter or press F2 on an cell in PBI desktop.