Ahmedabad Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Facing problem during creating a visualisation

  • 1.  Facing problem during creating a visualisation

    Posted Sep 16, 2020 11:08 AM
    Dear All,

    I have extracted data in .csv format from a unix server oracle 11g data base for the process parameters analysis. But, during creation of the table I m facing some problem. Table date column found as per the following format.
    29-JUN-20 11.01.01.000000000 PM +05:30

    My laptop/system date & time format is different than this that's why  getting error when I m making the column format as date & time.

    Please help me to resolve the issue. I can share the .csv data for better analysis. Anybody interested please post.


    Regards,
    Apurba Karak
    +91 8018043528

    ------------------------------
    Apurba Karak
    Engineering Department Electrical & Instrumentation
    Kolkata
    ------------------------------


  • 2.  RE: Facing problem during creating a visualisation

    Top Contributor
    Posted Sep 16, 2020 02:10 PM
    Hi Apurba,

    Can you share the CSV file or a sample ?

    In PowerQuery, you should be able to cleanup the date column.


    ------------------------------
    Vincent L.
    Chartered accountant - Expert-comptable
    ------------------------------



  • 3.  RE: Facing problem during creating a visualisation

    Posted Sep 17, 2020 10:05 AM
      |   view attached
    Hello Vincent ,

    Please find .csv file

    Regards,
    Apurba

    ------------------------------
    Apurba Karak
    Engineering Department Electrical & Instrumentation
    Kolkata
    ------------------------------

    Attachment(s)

    csv
    MON_HIS5MN_INDPOT_1 TO 50.csv   52.07MB 1 version


  • 4.  RE: Facing problem during creating a visualisation

    Posted Sep 17, 2020 10:09 AM
    Hi Vincent ,

    Following problem I am facing in Power BI desktop ,

    1) DH5MN column data type not able to select as Date & Time . Error Coming when I am selecting the data type as Date & Time
    2) When I m plotting DH5MN vs UMFC for INDPOT =1 then DH5MN not coming ascending or descending order in X axis.

    Please help me to sort out the issue.

    Regards,
    Apurba Karak

    ------------------------------
    Apurba Karak
    Engineering Department Electrical & Instrumentation
    Kolkata
    ------------------------------



  • 5.  RE: Facing problem during creating a visualisation

    Top Contributor
    Posted Sep 17, 2020 03:59 PM
      |   view attached
    Hi Apurba,

    For the first question, enclosed is a sample. I am not sure that it works on your computer as we don't have the same regional parameters.

    Basically here are the steps :
    1- Separate date from time : 1st column = date / 2nd column = time
    2- In the time column, only keep the 8 first caracters (remove the unnecessary 00000)
    3- Convert date column to a date format in Power Query (5TH SEPTEMBER will become 05/09/2020)
    4- In the time column : Replace points by colon (or other depending on your region)
    5- Convert the time column to a timeformat in Power Query
    6- If necessary, merge date & time columns into one single column and set it as Date/time format.

    I don't understand your second question.

    ------------------------------
    Vincent L.
    Chartered accountant - Expert-comptable
    ------------------------------

    Attachment(s)

    pbix
    1.pbix   85K 1 version


  • 6.  RE: Facing problem during creating a visualisation

    Posted Sep 18, 2020 11:07 AM
      |   view attached
    Hi Vincent ,

    Thanks for your support. I have applied the procedure & found working in my system. Please find the snap of my table.

    I will do my project & if any further query come then I will inform you.

    Again many many thanks for your support.

    Regards,
    Apurba Karak

    ------------------------------
    Apurba Karak
    Engineering Department Electrical & Instrumentation
    Kolkata
    ------------------------------



  • 7.  RE: Facing problem during creating a visualisation

    Top Contributor
    Posted Sep 18, 2020 04:53 PM
    Great news Apurba ! Well done.

    ------------------------------
    Vincent L.
    Chartered accountant - Expert-comptable
    ------------------------------