Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data conversion error

Hello,

 

I'm facing a problem when I am trying to convert my data into a decimal number.

My actual data is tagged as a text but PBI does not seem to take in count that I was using the correct format in Excel before the import.

 

I have already search for blanks but this is not the issue.

 

I need PBI to take in count decimal in order to produce diagrams and avoid the field "Count of ..."

 

How can I solve this ?

 

Thank you

 

 

General Comment
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Open Power Query, Before the first change data type step, use clean and trim

     

    Power Query Trim and Clean: https://youtu.be/NRYPsCnS0w4

    If needed replacevalues

     

    And they overwrite the datatype step and change datatype to decimal

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Open Power Query, Before the first change data type step, use clean and trim

     

    Power Query Trim and Clean: https://youtu.be/NRYPsCnS0w4

    If needed replacevalues

     

    And they overwrite the datatype step and change datatype to decimal

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you it is solved. 
    Now when I try to do visuals I can not mutualize my data.
    Indeed I have two data types in different tables :

    - Power which is part of energy table

    - Noise which is part of noise table

    Therefore I want to mutualize both depending on the collected date but both tables have their own collected date and only one is being printed.

     

    I have already tried to introduce cardinality and manage relationship but it did not work.